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

Hello there;

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 ]
Post subject: 

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