3,558 questions
0
votes
1
answer
347
views
An error occured while loading javascript modules, you may find more information in the devtools console (Odoo)
I overrided the default js method onDownloadButtonClicked (odoo/addons/web/static/src/views/pivot/pivot_render.js) for downloading xlsx files
(it`s my method) statis/src/js/views/my_render.js
/** @...
- 135
0
votes
1
answer
60
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:
...
- 49
2
votes
2
answers
152
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
123
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
99
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
88
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
105
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
125
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
114
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
80
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
73
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
98
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
89
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
105
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
0
votes
1
answer
79
views
Converting a .csv with data in one column to an .xlsx with multiple columns [closed]
I am working with .csv files automatically generated by a microscope. When I attempt to open the files in R, I find that all my data is grouped under a single column instead of under multiple columns ...
- 3
0
votes
1
answer
62
views
How to export Web Page UI as excel sheet using ReactJS
In my ReactJS application, I have a billing screen where users can create and preview bills. On the preview screen, there's an option to export the bill as an Excel file. I want the exported Excel ...
0
votes
1
answer
89
views
Is there a way to open, save and close an excel file (.xlsx)?
I've got a daily automated function in nodejs which builds and populates an excel spreadsheet via the package xlsx-populate, which has been running for a couple of years now with no problems.
A ...
- 111
1
vote
2
answers
82
views
OpenTBS for Excel MergeBlock does not push merged cells downward [closed]
When MergeBlock with openTBS for Excel, I notice that when populating rows with data, the merged cell that is under the row placeholder in the excel template does not get pushed down. it instead stay ...
- 353
1
vote
1
answer
106
views
Stream SheetJS xlsx to form-data in node
I need to generate and upload a xlsx in node. Any way to do this without saving the file to disk?
import FormData from 'form-data';
import XLSX from 'xlsx';
import * as fs from 'fs';
var form = new ...
- 1,118
0
votes
1
answer
26
views
XLSX parsing results for January 1st of each year are different from other dates? Why?
Abnormal reproduction: https://github.com/dingdangdog/xlsx-1-1-test
Why does this problem occur and how can I solve it?
- 35
1
vote
0
answers
104
views
Optimize memory using XLSX (sheetjs) package in node
I´m using the package XLSX from npm. In the project I read a file with a size of 420MB and it use a lot of RAM to do the work.
It´s a way to optimize the use of memory in this case?
This is a piece of ...
- 157
0
votes
1
answer
123
views
Generate and download .xlsx file using EPPlus in .net
I was trying to generate a .xlsx file and download it by using EPPlus package in .net. Below is the code I have tried.
using (var package = new OfficeOpenXml.ExcelPackage())
{
...
- 23
1
vote
1
answer
115
views
Is there a way of differentiating collapsed column in excel sheet via python
I am reading excel sheet via python and trying to read only visible rows in python (not hidden or collapsed). I went through documentation of OPENPYXL and found that it has "hidden" and &...
- 317
0
votes
0
answers
57
views
How to fill a xlsx file while keeping the original stylization with NestJS?
I'm developing an API that receives two dates, one to use as a start date and the other as an end date. After receiving them, I filter the database to get informations that are between both dates, and ...
- 1
0
votes
2
answers
107
views
How to denormalize hierarchical Django model data for rendering CSV or Excel with Djange REST Framework?
Assume, we are building an address book application with Django REST Framework and want to render an endpoint that exports all persons. Each person can have one or multiple phone numbers.
Exemplary ...
- 89
1
vote
2
answers
184
views
Reading an in-memory fetched xlsx file as JSON with Google App Script
I am using Google App Scripts built in function, UrlFetchApp.fetch, in order to request data from a URL. When you navigate to this URL in the browser, it just initiates a file download of an XLSX file....
- 107
1
vote
0
answers
117
views
Google Sheets 'Image in Cell' when converting to xlsx
So google sheets 'Image in Cell' option is awesome for organizing and stuff, but when I convert my sheet to xlsx and download it, it comes out of the cell and is larger (opening in numbers or ...
0
votes
0
answers
71
views
OpenXML creates XLSX file which needs repairs
Let me preface my question by saying that I have not changed this code in months, it has been working for years, I have not updated or modified external libraries.
I have a C# class that helps in ...
- 514
0
votes
0
answers
106
views
Is there a way to protect the workbook in exceljs/sheetjs or in any other node library?
Even if I pass the workbook which is password protected, it still removes the protection on the workbook.
I want the sheet to not remove the protection on the workbook.
It doesn't remove protection on ...
1
vote
0
answers
181
views
Draw lines in .xlsx files with C# (preferred OpenXml)
I want to draw a Line in a .xlsx file using a C# program. The line should be able to go from a starting-point to a lower placed point, that is to the left side of the starting point.
Example: from E5 (...
- 11
-1
votes
1
answer
151
views
Convert email attachment from HTML to XLSX
I have a shared mailbox that daily receives emails with an Excel attachment.
I have a power query to read the Excel file contents from each attachment in that inbox. It is failing because
Extension ...
- 103
1
vote
0
answers
26
views
How write correctly a Workbook in a HttpServletResponse using apache.poi
I'm trying to create a file xlsx after having created a workbook using apache.poi.
If I write it on disk, the file is created correctly but if I try to write on a response, I get always a file bigger ...
- 103
1
vote
1
answer
88
views
Javascript - Download xls file served from backend in blob format
I have a backend service writted in Java that will power the vue frontend app. I need to start the download of a file when it will be provided from the backend. At the moment I've noticed that the ...
- 3,678
0
votes
1
answer
358
views
Palantir Foundry import xlsx files [Excel from NAS]
I am in Palantir Foundry. I need to create a connection to a NAS folder that takes the xlsx files inside it.
The problem is that I do not create a dataset but a list of the xlsx files I connected to.
...
- 347
0
votes
0
answers
121
views
How can I open an .xlsx file from a shared OneDrive's link into R?
I'm working remotely and having an issue about a downloaded .xlsx file from a OneDrive's colleague. I was tired to download the .xlsx file daily from his OneDrive so I tried a code to get around this ...
- 11
0
votes
0
answers
952
views
Got error zip signature when read XLSX file inside zip file
I read some xlsx files that inside a zip file from multipart file. Here is my code:
for(MultipartFile file: files) {
if(Objects.requireNonNull(file.getContentType()).contains("application/x-zip-...
- 1
1
vote
2
answers
806
views
Is there alternative formula for =_xlfn._xlws.SORT($J$3:$M$17,4,1) in excel 2016
I need to to sort data from one table in another Identical table in descending order to procude a chart. Below are the tables
I need an alternative formula to sort
I have tried using =_xlfn._xlws.SORT(...
0
votes
0
answers
217
views
Export files to Excel XLSX file using C# and ClosedXML.Excel
I have a problem with exporting my data to Excel XLSX format using C# ASP.Net and ClosedXML.Excel
In practice when I execute the stored procedure "sProc_20241009" on the MySQL DB I have this ...
- 2,135
0
votes
0
answers
147
views
Changing font colour in XLSX file preserving all other style features using openxlsx2
Necessary preamble that will explain my clumsy syntax below: I am a novice with R and having developed in Python for ages I find the R syntax to be unclear form a OOP perspective (i.e. hard to find ...
0
votes
1
answer
131
views
How to create a .csv file with semicolon separation in XLSX npm
I'm triying to create a csv file with XLSX package from npm, and the result is the values separated by , (colon) and i want to be by ; (semicolon). How can I do it?
LSX.utils.book_append_sheet(...
- 157
0
votes
1
answer
83
views
Excel error when merging data using Openpyxl
I wrote this script:
import openpyxl
from openpyxl.styles import Alignment
from datetime import datetime, timedelta
Days = ["Monday", "Tuesday", "Wednesday", "...
1
vote
1
answer
78
views
Python .txt to .xlsx Conversion Chunking and Indexing Issue
I have a chunking and/or indexing issue with my python code where I am trying to convert a text script into an xlsx file. The problem is that xlsx files have a hard limit for the number of rows you ...
- 869
0
votes
0
answers
46
views
Triying to read an excel file greater than 100 MB with XLSX
I'm triying to read an excel file with a size of 103 MB using this code of XLSX pacakge from npm:
const options: XLSX.ParsingOptions = { cellDates: true, dateNF: "dd/mmmm/yyyy hh:ss:MMMM", ...
- 157
-4
votes
1
answer
174
views
How to convert csv to xlsx or build a xlsx file without external libs
So, i'm using NPOI to generate an XLSX file, but i note that it's very slow with so mutch data. I've created a workaround using CSV, but it's not good.
I learning about XLSX, and i can 'understand ...
- 48
1
vote
2
answers
1k
views
Converting excel file from xls to xlsx using Java programming
I'm a junior software engineer. Currently, I am struggling to convert an excel file from xls to xlsx without losing formats/formulas. I need your advise. I have been trying a few solutions using POI, ...
- 21
0
votes
2
answers
70
views
How to read the forward slash from an Excel sheet using Python?
I have an excel sheet with 20+ columns. If I want to select a row that doesn't contain the text n/a, is it possible to pass n/a as text and find it?
The code which I tried is:
import pandas as pd
...
- 1
2
votes
1
answer
113
views
Weird character conversion when _X2069_ is contained in input sheet for node-xlsx
I'm currently building a small command-line tool with Node and node-xlsx to parse and process some Excel files, and I noticed that whenever the input contains the sequence
_X2069_
node-xlsx seems to ...
- 30.5k
0
votes
1
answer
41
views
Can't Open .xlsx Document
I tried to download a .xlsx file from my course. But when I opened the .xlsx file, it turned into something like this.
UEsDBBQABgAIAAAAIQBBN4LPbgEAAAQFAAATAAgCW0NvbnRlbnRfVHlwZXNdLnhtbCCiBAIooAAC
...
- 79
0
votes
1
answer
45
views
XslxWriter returns zero to formulas (not even in the formula bar)
I tried writing formulas with xlsxWriter and the
worksheet.write_formula but in my excel I only have zero.
Datas are put in columns A and C but then the following formula returns a zero when I open ...
- 11
0
votes
0
answers
40
views
How can I import an .xlsx file in jupyter?
I need to import Database.xlsx in jupyter and be able to work on it with sql commands.
I'm using this code:
!pip install pandas==1.3.3
import pandas as pd
from pyspark.sql import SparkSession
# ...
