| EasyXLS http://forum.easyxls.com/ |
|
| Specify starting cell when writing to XL from DataSet http://forum.easyxls.com/viewtopic.php?f=5&t=116 |
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 http://www.phpbb.com/ |
|