Re: Outputting to Excel File
what are you trying to output?
Re: Outputting to Excel File
I'm trying to output the remains of a string after i've sliced it up.
Example piece would be
Club GP Wins Draws Loss GS GA GD Points
Stevenage 34 23 10 1 45 32 13 79
It outputs that sort of thing however it does it all within column A and then Row 1,2 etc.
Re: Outputting to Excel File
format the string. seperate columns with vbtab + rows with environment.newline.
copy to clipboard, select the correct number of cells (columns + rows) in excel as a range, then call range.paste.
Re: Outputting to Excel File
I have a thread in the .NET CodeBank that exports datatables and datareaders to Excel. While you are not doing either of those things, it would have the code in it to save data to different cells, which would be pretty much what you are looking for. That class loops through the fields in a datarow and saves each one to a subsequent column.