ExcelDataReader
ExcelReader reading blank lines from file that was disabled for editing
I had a file with 2 sheets in it, I only needed to parse the first sheet, however the reader was not able to pick up on any values, afterwards I opened the 2nd sheet which was disabled by default, after enabling it I re-ran the program and it picked up the values successfully. If enabling is needed for the reader, is there a way to do this in the reader configuration?
The file I have has sensitive information. I re-tried, after nothing was picked up again, I opened excel and found the security warning that the Macros have been disabled. This is what has been causing trouble. Can you advise?
On Mon, Jul 29, 2024 at 6:35 PM Johan Appelgren @.***> wrote:
Not sure, do you have a sample file that we can use to reproduce?
— Reply to this email directly, view it on GitHub https://github.com/ExcelDataReader/ExcelDataReader/issues/680#issuecomment-2256256551, or unsubscribe https://github.com/notifications/unsubscribe-auth/AF2M2RSHW74WS4QSBEGZB2TZOZOLJAVCNFSM6AAAAABLTXPWR6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENJWGI2TMNJVGE . You are receiving this because you authored the thread.Message ID: @.***>