Reply to topic  [ 2 posts ] 
Specify starting cell when writing to XL from DataSet 
Author Message

Joined: Fri Sep 28, 2007 12:00 pm
Posts: 1
Location: Dallas, Tx
Reply with quote
Post 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
Profile

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 199
Location: Brasov, Romania
Reply with quote
Post 
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
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 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

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.