Plugins - Excel tools

mohamedb over 8 years ago

I understand that the Excel Tools plugin provides expressions to read a specific excel cell by number or name.

Is there a way to Write to specific excel cells?

If there a way to add (and may be delete) tabs from an excel sheet?

Discussion posts and replies are publicly visible

Parents

0 Poorna Guduri
A Score Level 1
over 8 years ago

Hi mohamedb, There are 2 smart services - Export CDT To Excel, Export SQL to Excel - which comes with Excel Tools Shared Component itself. These 2 smart services have the ability to write to specific cells, through configuring the parameters - Cell_Keys & Cell_Values (considering the business requirement) - under Data/Inputs tab.
Coming to your second question, I think there is no such provision through any shared component.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Poorna Guduri
A Score Level 1
over 8 years ago

Hi mohamedb, There are 2 smart services - Export CDT To Excel, Export SQL to Excel - which comes with Excel Tools Shared Component itself. These 2 smart services have the ability to write to specific cells, through configuring the parameters - Cell_Keys & Cell_Values (considering the business requirement) - under Data/Inputs tab.
Coming to your second question, I think there is no such provision through any shared component.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data