|Specify starting cell when writing to XL from DataSet
|Page 1 of 1|
|Author:||jgrolon [ Fri Sep 28, 2007 12:20 pm ]|
|Post subject:||Specify starting cell when writing to XL from DataSet|
Using the easy_WriteXLSFile_FromDataSet() method, I can read data from a DB and send it to an XL spreadsheet. However, the method always uses cell A1 as the starting point to load the data.
Is there anyway(maybe a different method) to set a specific cell, other than A1, as the starting point when loading/writing data ?
I may just be missing a couple of obvious ways to achieve this.. I just started reviewing the app yesterday.. so my apologies if the answer is too obvious.
Thanks in advance for your help.
Juan G. Rolón
|Author:||daniela [ Mon Oct 01, 2007 4:32 am ]|
You can use one of the easy_WriteXLSFile_FromDataSet methods that has a start cell, like:
easy_WriteXLSFile_FromDataSet(System.String sPath, System.Data.DataSet ds, int startRow, int startCol, ExcelAutoFormat xlsAutoFormat, System.String sSheetName)
|Page 1 of 1||All times are UTC - 4 hours|
|Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group