3,574 questions
1
vote
0
answers
38
views
How can I choose the MIT license when using JSZip (dual licensed MIT or GPL) in my project?
I am currently using the xlsx library in my Cypress tests, which has a dependency on jszip.
When I checked the license for jszip, I found that it is dual-licensed under MIT OR GPL-3.0-or-later.
From ...
0
votes
0
answers
64
views
Issue reading google sheets data in R [closed]
I am working in a collaborative group around the world (different institutions) and we are trying to work on a synthesis project. We store our data in a shared Google Drive, meaning those files are in ...
0
votes
1
answer
27
views
Unable to construct record instance when using NPOI [closed]
I am using NPOI library in my .NET Core app to read a .xls file. Everything works fine on my local. When I deploy to IIS I see that the application is unable to read the .xls file and it gives error:
...
- 51
2
votes
2
answers
125
views
Issue with Number Formatting When Converting CSV to Excel Using Pandas
I'm having trouble with a Python script that converts CSV files to Excel format using pandas. The issue is that numbers in scientific notation in the CSV file are not being correctly interpreted as ...
- 107
0
votes
0
answers
81
views
Excel in-cell places image results in #VALUE! as type of error when xlsx file is extracted
When adding an in-cell image in Excel, extracting the xlsx file and inspecting the /xl/worksheets/sheet1.xml file, it seems that the in-cell image has value like this:
<row r="7" spans=&...
- 1
-3
votes
1
answer
86
views
Changing a predefined output name to user-selected name [closed]
I'm trying to get Python to export an xlsx file but give me a dialogue box to define the new filename / destination. I have managed to do it to select the initial file to load but unable to work out ...
- 17
0
votes
2
answers
69
views
Google Sheets export format set to CSV, downloads xlsx [closed]
I created a Google Sheet. It has one worksheet. I changed URL so it has export instead of edit and set ?format=csv. Here is the final URL:
https://docs.google.com/spreadsheets/d/{spreadsheet_id}/...
- 15
0
votes
1
answer
96
views
I have a database which exports Excel files but the column order changes on each export
I need to export Excel files from our database but keep (or quickly re-arrange) these so the columns remain in the same order as each other. The column headers are always the same but the order will ...
- 17
0
votes
3
answers
112
views
How list in pandas dataframe can be converted into multiple cells with no duplicate values?
I have this kind of data:
[{"id": 1, "name": "Alex", "projects": ["A", "B", "C"]}, {"id": 2, "name": "Bob&...
0
votes
1
answer
93
views
How to Export Chart Data from React Plotly.js to Excel on Button Click?
Iβm developing a React application with multiple charts using the Plotly.js library. I want to implement a feature where users can download the data used to generate the charts in an Excel file.
...
1
vote
1
answer
62
views
How to import one excel file with several sheets into R with import_list
I use the rio-Package to import one excel-file into my tidyverse. I only need the first two columns: The zip-code (plz) and the inhabitants (einwohner).
library(tidyverse)
library(rio)
url <- &...
- 73
0
votes
0
answers
63
views
XLSX Export not loading full sheet in Google Sheets
We get automated xlsx exports from a PaaS, in the past 2 months the exports they provide no longer fully load in Google Sheets when fields with the following characters exists (could be more but these ...
- 1
0
votes
0
answers
77
views
Python openpyxl issue when save xlsx file
I'm using Walmart template file to upload bulk listings to their site.
The template only allow 10.000 rows, so I have to split them into multiple files. The solution I'm using is to copy the original ...
- 343
0
votes
1
answer
77
views
How to import .xlsx in Jupyter Notebook from iPhone Carnets App?
I would like to try to work the dataset in Jupyter Notebook from the iPhone Carnets App, but I canβt search the correct path.
If someone can help me.
The dataset I download from Kaggle. Are free files ...
0
votes
1
answer
81
views
Why does 'exceljs' package delete the scripts in an excel file when the javascript program interacts with this excel file?
I have an excel file with a lot of scripts (office scripts). These scripts are linked with buttons inside the body of the excel file. I have written an Javascript app that I execute thought 'NodeJS'. ...
- 11