excel-tools
Service icon

Excel Tools

version 1.0.0 (Compatible with OutSystems 11)
Uploaded
 on 17 February 2023
 by 
0.0
 (0 ratings)
excel-tools

Excel Tools

Documentation
1.0.0

Excel Tools will allow you to:

  • Convert an old Excel file (XLS) to XLSX;
  • Convert any Excel file to CSV.


Converting to XLSX

You might want to update and old Excel file to the new standard.

To do so you want to:

  1. Develop how you want the user to upload the file (make the necessary validations for your use case)
  2. Call the ConvertExcel action and pass it
    1. The File you want to convert;
    2. The Format you want to convert the File to (in this case it should be Entities.ExportFormat.Excel).
  3. Handle any exceptions as you see fit (remember that the ConvertExcel action will throw an exception if the NewFile output parameter is NullBinary()
  4. Do what you see fit to ConvertExcel.NewFile (download, save to an entity, etc.)


Converting to CSV

You might want to convert an Excel file to a CSV.

To do so you want to:

  1. Develop how you want the user to upload the file (make the necessary validations for your use case)
  2. Call the ConvertExcel action and pass it
    1. The File you want to convert;
    2. The Format you want to convert the File to (in this case it should be Entities.ExportFormat.CSV).
  3. Handle any exceptions as you see fit (remember that the ConvertExcel action will throw an exception if the NewFile output parameter is NullBinary()
  4. Do what you see fit to ConvertExcel.NewFile (download, save to an entity, etc.) 


Note: you can find examples by downloading the ExcelToolsDemo