We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Consider a workbook that contains a "chart page" (described at https://support.microsoft.com/en-us/office/print-a-chart-on-a-full-page-581d7656-fdb7-4532-8e17-238d5879962e). An example can be found attached, named GDPTrackingModelDataAndForecasts.xlsx, taken from https://www.atlantafed.org/-/media/documents/cqer/researchcq/gdpnow/GDPTrackingModelDataAndForecasts.xlsx, with the chart page named "Chart1".
Accessing pages -- after the chart page -- by name do not result in the correct data being located. Consider the following code:
require 'open-uri' require 'simple_xlsx_reader'
doc2 = SimpleXlsxReader.parse(URI.open('https://www.atlantafed.org/-/media/documents/cqer/researchcq/gdpnow/GDPTrackingModelDataAndForecasts.xlsx')) ary2 = doc2.sheets.detect{|sht| sht.name == 'TrackRecord'}.rows.to_a
After running the code, ary2 contains the data from the page following the one desired, "TrackingDeepArchives".
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Consider a workbook that contains a "chart page" (described at https://support.microsoft.com/en-us/office/print-a-chart-on-a-full-page-581d7656-fdb7-4532-8e17-238d5879962e). An example can be found attached, named GDPTrackingModelDataAndForecasts.xlsx, taken from https://www.atlantafed.org/-/media/documents/cqer/researchcq/gdpnow/GDPTrackingModelDataAndForecasts.xlsx, with the chart page named "Chart1".
Accessing pages -- after the chart page -- by name do not result in the correct data being located. Consider the following code:
require 'open-uri' require 'simple_xlsx_reader'doc2 = SimpleXlsxReader.parse(URI.open('https://www.atlantafed.org/-/media/documents/cqer/researchcq/gdpnow/GDPTrackingModelDataAndForecasts.xlsx'))
ary2 = doc2.sheets.detect{|sht| sht.name == 'TrackRecord'}.rows.to_a
After running the code, ary2 contains the data from the page following the one desired, "TrackingDeepArchives".
The text was updated successfully, but these errors were encountered: