Hello,So, some context:I'm importing an Excel file to use as a template.I then edit that file.After I'm done, I generate a new binary and download it afterwards.The downloaded file will be imported in another program. Problem:The original Excel file has table names, but after downloading, some names are different in the generated file.The names must be preserved because they are referenced when importing in the other program. Evidence:Example when opening Excel's Name Manager from the original file (not the full list):Example when opening Excel's Name Manager from the generated file (not the full list) :As you can see the Refers To values are different. Code snipet:
I'm using the 'Excel_Package' extension.
This behavior happens even if I don't edit anything. I.e if I open the workbook, get the binary and close the workbook it changes the Name Manager Refer To values. What I'm trying to know is if this is a limitation of the component and/or if you have some suggestions I can try to implement? Thanks!Kind Regards,Luis Martins
Hi,
This component cannot be found in forge, I would like to suggest similar component if you still face issue with the Excel Package (O11) component. Try Advanced Excel which has similar functionalities, as it also uses EPPlus Library.Thanks
Hi VR,Thanks for the reply!I haven't tried to install in my personal environment but I guess you could try to install it from here: https://www.outsystems.com/forge/component-overview/1044/excel-package-o11I think the Advance Excel might be a little problematic, because the environment I'm using is shared with other applications that use the Excel_Package extension and the Advance Excel is not compatible/causes conflicts with that. I can only use one or another :/
Hi Luis
I tried with Excel package and try to format the background using Cell_FormatRange action, it is working fine, the data is not changed after manipulation using the component.
I suggest you to recheck the data type of the attributes in the excel matches with the structure you create inside Outsystems.
Thanks
Hi VR,Thanks for the reply! It's a bit difficult to verbalize my problem.
But the contents of Excel, the sheets and all the content that belongs to those sheets appears. Visually the file is fine.The only problem is when I open the excel name manager shortkey (CTRL+F3), it's different in one of them and they need to be the same.I don't know if it matters but the output extension is ".xlsm", I'm not sure if this component supports that extension.I'll try to leave a sample oml here later.