Hello all,Currently one of our clients use your component on their O11 environment, but we are on the process of migrating the applications the consume this component to the ODC environment as required by our client.Stuart has confirmed to me that there is a new version on the ODC environment called Excel_Library.Even though this Excel_Library is available on the ODC version, there are a few functionalities that I could not locate, for example, the Workbook_Open, Workbook_Close or the Workbook_GetBinaryData actions.What recomendations would the team have for these use cases?
Hi Thiago,
The ODC Excel_Library is not exactly the same as the OutSystems 11 library.
This is because of architectural differences. It is not possible to pass an object (eg the Excel document) back from the library.
You will notice the actions pass an Excel file in and return an updated excel file. So you no longer need Workbook_Open, Workbook_Close or Workbook_GetBinaryData.
Excel_Library documentation
At first I thought this would perform badly, however, when I looked at Cell_Write I noticed it was a "List" of values to write. So when generating data in a spreadsheet, only one call is necessary to write the data.
I recommend you perform a "spike" on the library and get familiar with how it works.
I hope you will find everything you need.
Kind regards,
Stuart
Sorry to revive an old post, but what you said only works for cell_write. What do you do for cell_read performance? You can read thousands of cells in a few seconds in O11, but in ODC one cell_read takes 30-70ms and you can't group them like cell_write. Am I missing something?
Hello Mehmet,
You are correct, and you are not missing something.
Cell_Read takes the whole Excel file, parses, then just reads an individual cell.
It would be ideal if the interface was extended to read multiple cell values, maybe by specifying a range, and/or the whole sheet in one call. However, so far that has not happened.
eg I imagine actions like this would be helpful Cells_Read, Row_Read, Column_Read, Range_Read and Worksheet_Read
Andreas, the awesome maintainer of the ODC Excel_Library just released a new version that introduces a Range_CellRead action. This will return a range of cell values in a single call.