Skip to main content
M
mrios0001
July 22, 2022
Question

Create Xlsx with multiple pages?

  • July 22, 2022
  • 10 replies
  • 0 views

Hello, 

So I have a business requirement to create an xlsx file report with multiple pages. 

I looked into the Excel plug-in and didn't find anything regarding that or similar. Does anyone know of a way to do it? 

Thanks in advance.

10 replies

mikes0011
mikes0011
Brainy
July 22, 2022

Can you specify what you mean by "Pages" here?  In an excel file you can add data rows to one (or many) workbooks, but that isn't exactly equivalent to the concept of "pages".

The Expression Guru
M
mrios0001Author
July 22, 2022

I am talking about sheets 

I have a request to add different data to different sheets. 

mikes0011
mikes0011
Brainy
July 22, 2022

The smart services that generate excel files allow you to specify the worksheet the data will be written to.

The Expression Guru
    D
    deepakg681722
    July 25, 2022

    There is a sheet number configuration available where you can define the sheet number and fulfil the requirement.

      M
      mrios0001Author
      July 25, 2022

      Do you know the name of the smartService? because the only one that allows me to select that is Convert Excel To CSV smartService from Excell Tools plug in

      D
      deepakg681722
      July 26, 2022

      There are many. if you want to export database data to Excel then we have Export DataStore entity to excel. If you want to export CDT data to excel then we can use export CDT to excel.

      Terms & ConditionsAccessibility statement