...
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 |
We've encountered an issue exporting this macro. Please try exporting this page again later.