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

asked 2019-07-31 08:30:49 -0500

shashikumar65 gravatar image

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 ?
edit retag flag offensive close merge delete

Comments

Have you tried reading an xlsm file with Excel data format? What happens if you do so?

metadaddy gravatar imagemetadaddy ( 2019-07-31 09:31:09 -0500 )edit