convert DataGridView Contents to Excel using SpreadSheetLight in C#

Question

so i'm trying to export the contents in a DataGridView to an Excel File. And for me to do this, i am using SpreadSheetLight for C#. But as far as reading the Sample Codes and Tutorials go, they're only demonstrating manual Excel content creation:

using (SLDocument sl = new SLDocument())
{
    sl.SetCellValue("B3", "It costs what for a Jimmy Choo?!?");
    sl.SaveAs("MahNewShoes.xlsx");
}

but what i want to achieve is to convert a whole DataGridView into SpreadSheetLight's Excel. If i am using a loop and loop the whole rows and columns of the DataGridView, how is it possible to set the Columns to A, B, C ... AA, BB, CC given that the loop uses integers ?.

hoping someone can give me a walk through here. thanks

score 1 · Accepted Answer · edited Jun 25 '16 at 01:53

1

int i= 0;
SLDocument sl = new SLDocument();

foreach (DataRow row in dtTransfer.Rows)
{
  sl[i, 0].SetCellValue("It costs what for a Jimmy Choo?!?");
  sl.SaveAs("MahNewShoes.xlsx");
  i++;
}

edited Jun 25 '16 at 01:53

Pang

9,564
146
81
122

answered May 31 '16 at 07:31

is `0` = column ?. how would you increment it ? given that `Column 0` in Excel is `A` ? – TheQuestioner May 31 '16 at 07:40
You can add any variable as int j = 0 and increment it into the foreach – May 31 '16 at 07:44
yes, but would `SpreadSheetLight` automatically convert int j to excel's column ? lets say j = 26, then it would be `Column Z` in Excel right ? – TheQuestioner May 31 '16 at 07:46
Yes sure. But j=25 will be as Z – May 31 '16 at 07:48
By the way you can use Aspose.dll too it is very easy. Say me you email address I will send you this dll for exporting to excell – May 31 '16 at 07:49
my only concern was the Columns since excel uses alphabet incrementation like `A, B, C .. AA, AB, AC` instead of numeric incrementation like `1, 2, 3 .. 27, 28, 29` which is the value of the counter in loops – TheQuestioner May 31 '16 at 07:51
you can send it to my public mail at `sof@skyenginetechnologies.xyz` thanks :) – TheQuestioner May 31 '16 at 07:53
No your offset must be only from 0. It is the one of the basis rules of the excel. – May 31 '16 at 07:55
i think i'm getting the hang of it. i'll try it first. thanks you :) – TheQuestioner May 31 '16 at 07:57
I have sent you. Don't forget feedback )) – May 31 '16 at 07:57
can you send it again ?. i haven't received it yet. thanks – TheQuestioner May 31 '16 at 08:02
Give me another email. It is returned.I will try to send again – May 31 '16 at 08:03

convert DataGridView Contents to Excel using SpreadSheetLight in C#

1 Answers1