View unanswered posts | View active topics
It is currently Wed Nov 27, 2024 12:46 pm
|
Page 1 of 1
|
[ 2 posts ] |
|
Specify starting cell when writing to XL from DataSet
Author |
Message |
jgrolon
Joined: Fri Sep 28, 2007 12:00 pm Posts: 1 Location: Dallas, Tx
|
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
|
Fri Sep 28, 2007 12:20 pm |
|
|
daniela
Joined: Fri Feb 03, 2006 12:23 pm Posts: 199 Location: Brasov, Romania
|
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)
|
Mon Oct 01, 2007 4:32 am |
|
|
|
Page 1 of 1
|
[ 2 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 1 guest |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|