GMExcel

Description

GMExcel can help you create, read, and rewrite Excel format files (*.xls, *.xlsx).

This is very easy to use.

We have some basic functions:

• excel_open(DocumentPath) // Open a document. Return DocumentID.

• excel_create(DocumentPath) // Create a document. Return DocumentID.

• excel_save(DocumentID) // Save.

• excel_close(DocumentID) // Close.

• excel_sheet_get(DocumentID) // Get all sheets in the document. Return a array of string.

• excel_sheet_add(DocumentID,SheetName) // Add a sheet.

• excel_sheet_clone(DocumentID,SheetName1,SheetName2) // Clone (SheetName1) to (SheetName2)

• excel_sheet_delete(DocumentID,SheetName) // Delete (SheetName)

• excel_sheet_color(DocumentID,SheetName,r,g,b) // Color (SheetName)

And some functions for getting and setting:

• excel_set(DocumentID,SheetName,Cell,Value) // Set

For example: excel_set(DocumentID,SheetName,"A2","Hello GMExcel") // Set A2 to Hello GMExcel.

• excel_get(DocumentID,SheetName,Cell) // Get

• excel_get_exist_range(DocumentID,SheetName,Cell1,Cell2) // Get a array of text from Cell1 to Cell2.

End User Licence Agreement (EULA).

Age Rating: 4+