Has anybody used/evaluated both of these libraries and can tell me the difference? Otherwise has anyone here used SmartXLS for reading/creating/updating excel files and can tell me his experience? The later is considerably cheaper than the former. ...
I can see first line as XML tag in previous Excel 2007,but not in Excel 2010. I tried many times to find out how to import and keep first line as XML tag. Is there anyone face the same problem like me? Thanks for help. ...
I am emailed an excel attachment that has a row of data that is updated daily. (for example, A1 10/21/10 B1 10 C1 19 A2 10/22/10 B2 09 C2 41 A3 10/23/10..... I need to create a macro, that when once the attachemnt is open from the email I can run the macro from another excel file that will copy the data for the curre...
I would like to be able to copy one row and five columns from an Excel spreadsheet to a table like structure on a ASP.NET web form. The idea is keeping the data in the exact row and column from Excel to the table like control on the ASP.NET web-form. Then I want to be able to save to the contents of the ASP.NET control to a database b...
I'm trying to use Microsoft.Office.Interop.Excel. It seems to load fine but when I try to use it, all the defaults parameters are not working. Here is a screenshot that shows all those bad values Whenever I try to ommit them, the compiler tells me that the function needs more than 1 parameter. This function is Open as in : Micros...
I need to host Excel spreadsheet in our WinForms app. It looks loading the excel file into WebBrowser control is the way to go. There are several articles on the Internet about this. However, they mostly use Excel 2003 (I guess). Excel 2007 presents some new problems: By default, the Excel spreadsheet is opened up in a new window, inst...
is excel's columns limited to 256 ? i try to fill my excel file with a matrix of 1200 x 800 and it doesn't seem to work ( i recieve an error that states that any data beyond the 256 column will not be saved ) . any ideas how this could be avoided ? Regards, Alexandru Badescu ...
My client needs to read some queries using Excel or something like it, so I need to generate XLS calling in some queries in stored procedures. Basically I have the SP, I have the View Done, and the query working fine, but I don't know how to make an xls or an xlsx with the SP itself. Is there any good practice or some specific steps I...
Hi all. I know this is a total noob question, but can anyone tell me why this function always returns 0: Function Cd(Re As Double) Select Case Re Case Re < 1 Cd = 24 / Re Case 1 < Re < 1000 Cd = 18 * Re ^ (-0.6) Case 1000 < Re Cd = 0.44 End Select End Function Whenever I call it in the spreadshe...
There are many, many questions and quality answers on SO regarding how to prevent leading zeroes from getting stripped when importing to or exporting from Excel. However, I already have a spreadsheet that has values in it that were truncated as numbers when, in fact, they should have been handled as strings. I need to clean up the data...
I'm working with a dynamic array in Excel VBA. The number of columns (m) is fixed, however, I do not know how many rows (n) will be required. The help documents state that ReDim Preserve myArray(n, m) allows me to make m larger, but not n. However, I need to increase the number of rows (n) while preserving my data, not columns (m)! F...
1) I am using Word 2007. I have a document with several section breaks. Now I want to add a page number to every page in the footer section. When I use Insert - Footer, it starts with 1 for every section. There are hundreds of sections and I do not want to press "same as previous" button for each section. How do I insert continuous page ...
Two-headed question here guys, First, I've been trying to do some searching for a way to read .xlsx files in python. Does xlrd read .xlsx files now? If not, what's the recommended way to read/write to such a file? Second, I have two files with similar information. One primary field with scoping subfields (like coordinates(the primary ...
Hello, i have a column A with about 10,000 random numbers. I want to perform a function ( =MAX() for instance) on group of 100 numbers every time, i.e. i want to do =MAX(A1:A101) then =MAX(A102:A202) =MAX(A203:A303) etc... notice there's no overlapping in the groups. normal Dragging doesn't work, it will perform jumps of 1 for...
Hey, I have an excel document with columns A and B. Row A has 2595 values. Row B has 411 values. I'm trying to figure out how I can compare these two columns by marking column C with the number of times we find a value(s) from row a. For Example COLUMN A COLUMN B COLUMN C 1 1 1 (becaus...
I have a site using a self-signed cert (which prompts for "trust this site and continue"), and in IE, occasionally when the user attempts to download a CSV file (which is handled by writing the file to the file system and sending a redirect header), the user can be prompted with the Windows authentication screen for username/password. T...
Many of Excel's built-in functions can take array arguments. Sometimes the result is documented in the help and sometimes not. So: =IF({1,0,1}, 42, 99) will return {42, 99, 42}. The help for 'IF' covers array arguments. But: =INDEX({2,3,5,7,11}, {2,4}) will return {3, 7}. This is intuitive, but I can't find a Microsoft source that ...
I'm jut trying to import a spreadsheet into a table in Access 2000. The spreadsheet is called cc-ledgcodebalances.xls with no field names. My code is DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3, "tmptmp", VFileName, 0 This seemed to work once but since then I now get this; The Microsoft Jet database engine could not ...
Hello, My application is supposed to parse a text file (relatively easy) and create an excel spreadsheet report. Should I write a stand alone VB.NET application that saves the excel file, or should I use VSTO? I am unsure if there are any differences in terms of ease of development, usability issues, API functions available, etc. Are...
Hi, I am working on a task where I should fill in some data in an excel workbook (using .NET) and the existing chart objects would draw line graphs based on the given data. Unfortunately, a macro in the workbook throws an error "Unable to set MinimumScaleIsAuto property of Axis class". ActiveSheet.ChartObjects("Chart 1").Activate Activ...