17
Views
0
Comments
[Excel Package] Open the workbook anb Get the Binary Data changes the format of a Protected file
excel-package
Web icon
Forge asset by Alfaro
Application Type
Traditional Web

I'm having an issue when managing excel files (using Excel_Package) that are imported with protected view active.
Scenario: 
- Upload an excel file with protected view active
- Run an action that opens the Workbook (Workbook_Open_BinaryData)
- update the data (not relevant, we can exclue this action)
- Get the binary data (Workbook_GetBinaryData) and export the data.
When downloading the file, the file it's currupted. However, you can open it, the date is there, but some columns are not correctly formated (date and integer columns)

Any ideia about how to solve this issue?


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.