Now this is a weird one We have a project where we are reading some data from an Excel spreadsheet. Obviously this data has to be in a certain format. Some of the fields consists of numbers, but should be treated as text. To stop Excel from being "smart" and change the cell types, I have set the format in the respective cells to 'text'...
What I have to do I'm trying to manipulate some rather large amounts of data stored in Excel files (one of the workbooks has as much as 150 spreadsheets). The result of these manipulations may yield approximately 800.000 rows in a database table. The problem Data stored in the spreadsheets has unpredictable format. The company that ge...
What is the best way of representing a DateTime in Excel? We use Syncfusions Essential XlsIO to output values to an Excel document which works great. But I can't figure out how to display a DateTime in a column. Not when doing it myself directly in Excel either. Is it impossible? Do I have to use a separate date and a time column? I real...
I am trying to export an excel file directory into an Oracle table as opposed to looping through the range and executing a lot of insert statements. I would think that there are better ways to accomplish this in .NET but I can't seem to find any other answer besides convert excel to csv & load it using Sql Loader or External Table. Does ...
Hi all, I have a method in my macro that executes the following code: Set myDocument = Worksheets("sheet1") For each sh in myDocument.Shapes If sh.Name = "square" Then sh.Cut End If Next My problem is that the code causes an error on the line sh.Cut. I know that there is a shape called "square" - I can see (visually) ...
Hi, I am using SpreadsheetClass to write some data to a excel sheet through c# code. It was working fine. Now it has started giving an error in this line. SpreadsheetClass xlsheet = new SpreadsheetClass(); Eroor is Retrieving the COM class factory for component with CLSID {0002E510-0000-0000-C000-000000000046} failed due to the fo...
As part of an overhaul of a report generator I saw what I believed to be inefficient code. This part of the code runs after the main report is generated to set the page breaks in logical positions. The criteria is this: Each Site starts on a new page. Group's aren't allowed to broken across pages. The code follows the above format: 2...
how to pass string array from C/C++ dll to vba (Excel) dll in Visual Studio dll is not managed, ATL, etc. regards Andy ...
I am looking for a way to show additional information (columns) when doing subtotals beyond the columns that you are using On Change and are doing a function to (sum, min etc). A simple example, I have the following data, which has 5 columns of information: Zip Code Media Sunday Zip Code Circulation 3082 Bluebell 3,456,284 551 ...
is there a simple way in vb.net to load an excel file and read it? perhaps there is a way to load the file but have it not be visible to the user? ...
In Excel, there's a function called "MAX" that accepts numbers and returns the largest one in the set. Is there a function in T-SQL that duplicates this functionality? I haven't been able to find one, and I've written a UDF that does it for me, but I thought it was worth asking. Here is the function I've been using: CREATE FUNCTION dbo...
How can I use C# to export data to Microsoft Excel from MS-SQL? Can anyone give me a sample of coding or related tutorial to connect to a database and click a button to export to Microsoft Excel? ...
Hi Folks, I am trying to use a VBA macro (for Office 2003) to do the following: In Excel, the user will select a range of cells In Word the user will call the macro (via a button or shortcut) to insert the selected Excel range as an embedded object The code is not the problem so far, my problems are: Given that the user is working...
Is there any way to use server controls in ASP.NET MVC? Specifically I need to use the FarPoint Spread control in my application to display an Excel file that exists on the server with the ability to display updates on the client in real time. The reason that I want to use MVC instead of webforms is that eventually we're going to scr...
There is cell which written URL was in around 1,000 lines per the seat. I want to do the following. to make only specific keyword a blank. to omit duplicated URL. Please help me ...
Hi All, I am using the following code to extract the sheet names from excel: (See attached code) But the data is returned sorted by the NAMES of the sheets, and this is the issue. I need to extract the name of the first sheet, by index. How can I do this? String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + ...
To all, I have an Excel spreadsheet pivot table that is linked to an SSAS data source. The employee counts are aggregated and return the following values: Row Label Count North America 7 South America 2 Europe 5 Asia 1 Australia 3 Let's say the user modifies the South America Row to read ...
Hi all, The question title is probably not correct because part of my question is to try and get some more understanding on the problem. I am looking for the advantages of making sure data that is imported to a database (simple example: Excel table to Access database) should be given using the same schema and should also be valid to th...
I would like to bulk replace the "07" part of a list of strings (mobile telephone numbers) with the international version "447". The list of strings currently forms a columnn in an Excel spreadsheet. I have the regular expression to match strings requiring modification: ^07[0-9]{9}$ ...but I don't know how to do the replacement that...
I want to implement functionality in PHP similar to what is available as Goal Seek in Microsoft Excel. Is such a thing possible to implement in PHP? Here is the story in detail We are writing a Personal Loan Management application for a financial company. They are at present using Excel sheets to do all kind of load, EMI, etc. calcula...