openpyxl - XLRD intermittently reads Bloomberg excel formulas -
i using xlrd
gather data excel sheet, performing calculations , writing same sheet (writing using openpyxl
preserve .xlsx
file type). part of data gathering uses bloomberg
formulas automatically gather data in excel.
xlrd
can read few times, if run script more 3-4 times fails. data gathering strings, , when fails, reads in empty strings. formulas still preserved on sheet , data still there, data being read in doesn't work.
does have insight issue, or way ensure compatibility in reading in info? thanks!
Comments
Post a Comment