Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

how to convert macro enabled the .xlsm to .xlsx using streamsets

Description: We are getting macro enabled .xlsm file from the source and i need to convert to .xlsx and load the data to teradata tables using streamsets.

Question:

  • Can we convert the macro enabled .xlsm file to excel file .xlsx at the beginning using streamsets ?
  • If possible to do it in streamsets, please let me know how to do it at the beginning in streamsets ?
  • If you have any alternative approaches to do the conversion, please let me know ?