Created by Davide Carpi in the scope of SMath project. Published by Davide Carpi.
This is Open Source project. Sources shared under MIT Licence and available in public SVN repository.

Features of XLSX Import/Export

Version 1.3.7845.24796

Functions

Additional components that add new mathematical functions to the SMath Studio program, necessary for solving problems from various fields.

  1. exportData.XLSX("1:variable", "2:string")
    Export "1:variable" into a "2:string".xlsx spreadsheet; the file will be placed in the current working directory. The function returns '1' if successful.
  2. exportData.XLSX("1:variable", "2:string", "3:string")
    Export "1:variable" into a "2:string".xlsx spreadsheet; the file will be placed in the "3:string" path. The function returns '1' if successful.
  3. exportData.XLSX("1:variable", "2:string", "3:string", "4:string")
    Export "1:variable" into a "2:string".xlsx spreadsheet; the file will be placed in the current working directory. Data will be written in the "3:string" sheet, starting from the "4:string" cell. If the file or the worksheet exists, data in target cells will be overwritten. The function returns '1' if successful.
  4. exportData.XLSX("1:variable", "2:string", "3:string", "4:string", "5:string")
    Export "1:variable" into a "2:string".xlsx spreadsheet; the file will be placed in the "3:string" path. Data will be written in the "4:string" sheet, starting from the "5:string" cell. If the file or the worksheet exists, data in target cells will be overwritten. The function returns '1' if successful.
  5. importData.XLSX("1:string", "2:string")
    Import XLSX spreadsheet data from "1:string" path; get all data from "2:string" sheet name.
  6. importData.XLSX("1:string", "2:string", "3:string")
    Import XLSX spreadsheet data from "1:string" path; search data into "2:string" sheet name and "3:string" cell or range of cells.
  7. importData.XLSX("1:string", "2:string", "3:string", "4:string")
    Import XLSX spreadsheet data from "1:string" path; search data into "2:string" sheet name, from "3:string" cell to "4:string" cell.