Questions and answers on how to use XLSReadWriteII 3/4/5.
Zul-Jin
Posts: 3 Joined: Thu Dec 15, 2005 4:50 pm
Post
by Zul-Jin » Tue Dec 12, 2006 11:37 am
After this code Format has been applied for each cell in the sheet.
Why?
And why BorderTopStyle hasn't been applied?
Sample:
TCellFormat * F = XLS->Formats->Add();
F->XFont->Size = 15;
F->XFont->Color = xcRed;
F->BorderTopStyle = cbsThick;
XLS->Sheets->Items[0]->IntWriteNumber(1, 1, 0, 3456);
XLS->Write();
Zul-Jin
Posts: 3 Joined: Thu Dec 15, 2005 4:50 pm
Post
by Zul-Jin » Tue Dec 12, 2006 11:40 am
I use XLS version 3.00.06
larsa
Site Admin
Posts: 926 Joined: Mon Jun 27, 2005 9:30 pm
Post
by larsa » Wed Dec 13, 2006 7:55 am
Hello
Cells shall be formatted trough the Cell or Range properties. Don't use any IntWriteXXX methods. These are only for internal use, and will not be available in future releases.
Please study the FormatCells sample.
Lars Arvidsson