A simple, friendly interface for xslx, that allows easy creation of new Excel spreadsheets and simple editing of existing ones.
Creating a new spreadsheet and adding a little data is easy.
// the Worksheet object gives you a simple interface to a single sheetvar Worksheet = Worksheet;var worksheet = "Hello Spreadsheet";// add data using row and column indices on the worksheet objectworksheet00 = "Hello";worksheet01 = "Spreadsheet";// saving automatically creates a new workbook with the same namevar workbook = worksheet;
Creating a workbook with multiple sheets is a snap!
// the Workbook object gives you more control and stores multiple sheetsvar Workbook = Workbook;var workbook = ;var sales = workbook;var costs = workbook;sales00 = 30450;sales10 = 15924;sales20 = 49338;costs00 = 10250;costs10 = 5914;costs20 = 27332;// automatically appends the '.xlsx' extensionworkbook;
Editing existing workbooks is easy too!
var Workbook = Workbook;// looks for a file with a '.xlsx' extensionvar wb = "Revenue-Summary";var sales = wb"Sales";var costs = wb"Costs";var profits = wb;fori = 0; i < saleslength; i++profitsi0 = salesi0 - costsi0;wb;