Wb.save(Fresource_path_output('outputFile/outputData.xlsm'))Īt the end it gives an error, when trying to open the excel file. Sub ImportWorksheet () This macro will import a file into this workbook Sheets ('Sheet1').Select PathName Range ('D3').Value Filename Range ('D4').Value TabName Range ('D5').Value ControlFile ActiveWorkbook.Name Workbooks.Open Filename:PathName & Filename ActiveSheet. XML parts within the package, you’ll find. So it’s basically a ZIP container, and you can open it with any ZIP tool to see what’s inside. Print('write_to_excel_file_withOpenpyxl',Fresource_path_output('outputFile/outputData.xlsm')) The XLSB format (also sometimes referred to as BIFF12, as in binary file format for Office 12) uses the same Open Packaging Convention used by the Open XML formats and XPS. Print('converte2',value_from_output_file,value_to_write_df)ĭef write_to_excel_file_withOpenpyxl(colName,data):

Print('column amount is different input and output csv files, please review both files')ĭef converter_of_two_results2(lst_inp,lst_outp,rowValues,path_v): Write_to_excel_file_withOpenpyxl(conditional_for_columnNames(value_from_output_file),value_to_write_df) Print('converter1',value_to_write_df,value_from_output_file) Print(maximum_row,'maximum' ,ws.max_row,'ws.MAXimum row')ĭef converter_of_two_results(lst_inp,lst_outp,rowValues,path_v): Print('fndMaxRowInSheet',Fresource_path_output('outputFile/outputData.xlsm')) Wb = load_workbook(Fresource_path_output('outputFile/outputData.xlsm'), keep_vba=True)

The code is below def fndMaxRowInSheet(): It uses the extension to choose which Excel engine to use. I underline xlsm extension for those developers who undertands me that sometimes it gives unknown errors when file is xlsm, but exports perfectly data to xlsx file. Code-Write pandas dataframe to xlsm file (Excel with Macros enabled)-pandas score:15 Accepted answer Pandas requires that a workbook name ends in. The file written has already some data and has an extension of macro-enabled (xlsm). I am writing data to excel file with openpyxl framework.

How to use xlsm file