Davide CarpiSMath项目的作用域中创建。由Davide Carpi发布。
这是一个开源项目。MIT许可证下共享的源代码SVN存储库

Features of XLSX Import/Export

版本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.