...
That may not seem much, but, if you look at the Excel Connector, for instance, you will see why we love this feature.
| Code Block | ||
|---|---|---|
| ||
use "excel";
int fid = openWorkbook("test.xlsx"); //excelOpenWorkbook
addSheet(fid, "Data" , true); //makes it current, full name 'excelAddSheet'
addRow(fid, 0); //excelAddRow
setCurrentSheet(fid, "Sheet1"); //excel....you got the point!
addRow(fid, 0);
setCell(fid, "Value 1", "A1");
setCell(fid, 12001, 0, 1);
setCell(fid, "Value 2", "Data", 0, 0);
setCell(fid, 20010, "Data", 0, 1);
closeWorkbook(fid); //save it |