Newest 'xlsx' Questions - Stack Overflow

Questions tagged [xlsx]

xlsx is the file extension for files created using the default format of Microsoft Excel 2007 or higher.

0
votes
0answers
6 views

Inserting new row / note at the beginning of a sheet during XLSX Export

I am new to node.js and I am able to write my data into workbook but I am facing an issue with inserting a note at the beginning of my data. Please note that the data is being fetched from DB but ...
2
votes
2answers
29 views

How to convert blob to xlsx or csv?

The frontend of the application having a file download option (which can be in the following format: xlsx, csv, dat). For that, I use fileSaver.js Everything works fine for the format .dat/.csv but ...
-1
votes
0answers
13 views

Getting error while trying to fetch the column values using python openpyxl

I have written a python script which should return columns values from a spreadsheet but getting error while trying to iterate. Referred openpyxl doc. #Accessing MS Updates Excel File wb = ...
0
votes
0answers
9 views

Identify what packages can open xls file [duplicate]

I have an APP that makes a system call to open an internally generated xls file. 1st I need my app to identify which applications installed on the system allow you to open this type of files. 2nd ...
0
votes
0answers
27 views

Extract specific fields from JSON and export CSV or XLSX with formatting

I have some JSON that I need to grab specific data from and create a downloadable CSV. I have a JSON file already retrieved from an API, but I need to extract only 12 of the 32 available values - ...
0
votes
0answers
6 views

XLSX - UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'length' of undefined

there is some code i write, how can i fix this const main = async () => { const data = await query(); const workbook = xlsx.utils.book_new(); const worksheet = xlsx.utils.json_to_sheet(...
0
votes
0answers
30 views

How to manipulate a .xlsx data with using nested for loops in R?

This is what the sample looks like: Year Categories January February March April May June July August September October November December 1990 A 4564.0 ...
0
votes
0answers
11 views

importing excel sheet that does complex calculations to swift and doing calculations through it ( tried xlsxReaderWriter Pod but failed )

i have an Excel sheet xlsx, i need to write data to it and then read the result after it does the calculations, all through my app , i tried the xlsxReaderWriter Pod but it doesn't make the ...
0
votes
0answers
13 views

XLSX.utils.table_to_book-How to insert rows at the start of a sheet , do not replace data?

how to insert rows at the start of a sheet , do not replace data? I am doing var wb = XLSX.utils.table_to_book(document.getElementById('table')) XLSX.utils.sheet_add_json(wb.Sheets.Sheet1,[...
0
votes
0answers
15 views

How can I merge multiple sheets of an excel with same columns and some equal data in row

I have an excel file that has 4 sheets with the same columns. there is an important point, Some row has equal data. For instance. Same Email and Name for each person. How can I merge these multiple ...
0
votes
0answers
16 views

How to edit an existing excel cell value into a date

This excel file returns the cell values (numbers from 1-30) as strings. I convert them to integers because if it's above 16, it indicates it's a day in June. If it's below 17 it's July (this is due ...
0
votes
0answers
12 views

read xlsx template , write data using javascript/jQuery and download as seprate file

I have a xlsx template that i wish to call from client side when a button is clicked and then the data on the screen get imported to it using arraylist or json array.(the lists are already created st ...
0
votes
0answers
23 views

How to combine multiple xlsx sheets into one DataFrame/JSON object?

I need to turn an excel workbook (xlsx file) with multiple sheets into a JSON object that will preserve the sheets structure and names. To do this, I am using pandas. However, I haven't been able to ...
0
votes
1answer
14 views

XLSX library for Kotlin Native

I am working on a Kotlin Native project, which main purpose is to generate reports in .xlsx format. Which library should I use for working with .xlsx files? I only need to create new files, so the ...
0
votes
0answers
6 views

Debugging in visual studio code throwing exception in node_modules

To demo the issue with debugging, below is the code which I am trying to run in vscode: const XLSX = require('xlsx'); console.log("imported xlsx" + XLSX); When I try to debug this in vscode, I get ...
0
votes
0answers
20 views

Is there any way to write xlsx file without using any phpexcel library like csv or xml file

I have tried creating simple .xlsx file like the way I would crate .csv file. File has been generated and it works fine in ubuntu. But in windows, the same file cannot be opened it says, invalid file ...
0
votes
1answer
17 views

Set workbook's date system to 1904 with Apache POI

Using Apache POI, I need to have negative durations in Excel in some of my cells, like this -03:35:13. Also the underlying value needs to be an actual negative numeric, not a text, because people ...
-1
votes
1answer
38 views

Convert Date (dd/mm/yyyy) to Excel Serial Number in JavaScript [duplicate]

Description: I am generating an Excel file using the XLSX on an Angular Project (npm install xlsx), but I am facing a problem showing a precise date. If I try to use JavaScript date object it ...
0
votes
0answers
20 views

How i remove column using xlsx library in angular application

How to remove the last column from a table using the xlsx library? I'm saving my table from my angular application, but I wanted to remove the last column named "description" because it's just an ...
0
votes
0answers
18 views

Get the type of CELL when we are using xlsx-StreamReader and apache-poi

I am trying to read lareg excel mainly using POI and XLSX-STREAMER below are the jar and there versions that i am using currently. I can not use other jar version then below because of some reasons. ...
0
votes
0answers
11 views

Unable to set type for date field using XLSX in Angular 6

i am working on a scenario, in which i have to import the excel and i am facing issue for the date conversion. I am giving the date as dd/mm/yyy hh:mm:ss format in excel, but my date is not converting ...
2
votes
1answer
28 views

How to import desgin of an Excel Template in Angular as Object

I want to Import data from Excel, after modification i want to export the updated data. I am able to import data from Excel file using XLSX package, but while i export the new data, all the styling ...
0
votes
2answers
33 views

Upload csv file to aws s3 bucket directly from a server

Happy weekend all, I'm working on a task that fetches data from an API then store them into a csv file then from there directly upload to AWS S3 bucket. I've tried several ways but I'm currently ...
0
votes
1answer
33 views

None values after reading more than 10000 rows of .xlsx file in openpyxl

I'm working on a application that can read out a large .xlsx (more than 20000 rows) with Openpyxl and can make some basic calculations with this data. I try to read out 20000 rows in the example below....
0
votes
0answers
12 views

Is there a way to open a local doc or xlsx file inside the app?

Is there a way to open a local doc or xlsx file inside the app? iOS allows to open all types of documents inside webview, is there a way to do the same in Android?
0
votes
0answers
43 views

Sort rows in XLSX file with Apache POI

I try to sort sheet with use of Apache POI by a given column. As I know there isn't any built-in solution for this purpose. First row of sheet contains merged cells and grouped columns. I try to sort ...
0
votes
1answer
61 views

Trouble getting StreamingReader to work with Excel xlsx Java

This is the code that I have for reading a very large excel file (xlsx) that is 23.5MB with 700,000+ rows. String dir = rootPath + File.separator + "tmpFiles" + File.separator + FILE_NAME; File ...
-1
votes
1answer
25 views

While exporting to xlsx file, 20 digits number will display 15 digits followed by 5 zeros

While exporting to xlsx file, 20 digits number will display 15 digits followed by 5 zeros
0
votes
1answer
74 views

Write CSV content to Excel produces empty sheets

Writing DataFrame to excel file leaves sheets with zero data. I am creating a Robotics "Scouting application". It receives multiple .csv files throughout the coarse of two days. The csv files will be ...
0
votes
0answers
17 views

Can't create Workbook

failed to use package 'xlsx' to createWorkbook() R--3.4.4 Windows 7 wb<-createWorkbook() Error in .jnew("org/apache/poi/xssf/usermodel/XSSFWorkbook") : Java Exception (no description because ...
0
votes
1answer
33 views

How to change color of excel cells with pandas (python)

I'm trying to compare two excel files and then output the non equal values into a new excel file. Currently in the excel3 file it will display (value in excel1) --> (value in excel2) but I also want ...
0
votes
1answer
23 views

xlsx package can't be loaded

XLSX package is not loading in WIndows 7 with Rstudio 3.5.3 Error: package or namespace load failed for ‘xlsx’: .onLoad failed in loadNamespace() for 'rJava', details: call: fun(libname, pkgname) ...
0
votes
1answer
33 views

In R, is it possible to write an empty data frame with no observations but with column names to an Excel Sheet?

I have 2 data frame: one with observations and one with no observations. I am using the "xlsx" package to write the data frame to an Excel Sheet. Because the second data frame has no observations, the ...
0
votes
1answer
39 views

How to update dataframe values based on conditions?

I am needing to see how I can update dataframe values in R based on a condition and then use a query to SQL Server to make the calculations and replace that value within the dataframe. Right now for ...
-2
votes
0answers
23 views

How to create XLS files using c# [SpreadsheetDocument.Create()] [duplicate]

i am trying to create xls file using the following fucntion, SpreadsheetDocument spreadSheet = SpreadsheetDocument.Create(cDestinationFilePath, SpreadsheetDocumentType.Workbook ) but it seems to ...
0
votes
1answer
22 views

Convert a .xlsx file to .xls without losing data using Python

There was a need to convert the .xlsx file to .xls. Existing types of solutions using opepyxl and win32.com lead to data loss, some formulary dependencies implemented in .xlsx formats. Is there any ...
0
votes
0answers
22 views

Parse XLSX into JSON

I am trying to parse Excel content into JSON using the xlsx npm module, however it doesn't return any content. Why don't I find anything inside workbook.Sheets? Example: var workbook = XLSX....
0
votes
0answers
8 views

Updating specific sheet(tab) on an existing Excel file from an another .xlsx file

I want to update specific sheet(tab) for all row and columns (2086, 20) - let's say "SHEET_UPDATE" on an existing Excel file using another .xlsx file (update.xlsx) and save it as original existing ...
0
votes
1answer
52 views

Export a data frame as multiple worksheets in a single Excel file in R

I have a dataframe like this dummy data: df <- data.frame( stringsAsFactors = FALSE, id = c( "100-1", "100-1", "100-2", "100-2", "100-5", "100-5", "100-5", "...
0
votes
2answers
26 views

Remove duplicate records from React Table

I am reading a Excel file,convert those data into json and showing those data in a react table. The code below is the method that I use to read and set those data in to the state. handleFiles = ...
0
votes
0answers
41 views

Why does the output of pd.read_csv() and pd.read_excel() deliver a dataframe with different functioning column headers?

I'm importing an .xlsx file with pd.read_excel(). I received this .xlsx file as an CSV file and used excel to seperate it by comma so I get the proper .xlsx file with columns etc. Six of the ...
0
votes
2answers
39 views

Getting Last Modified by Name of xlsx file

I have an excel file that gets modified by a group of people and we need to keep track of when the file was last modified and by whom I was able to retrieve the file properties through .properties ...
0
votes
0answers
10 views

How to store json object to S3 as xls/xslx file using node.js

Am new to node.js trying to find a solution to fetch a resultset (json) from query and upload it to s3 as xls/xlsx file.
0
votes
1answer
32 views

How to include .xlsx and .docx files in Typescript compilation output?

I'm using Typescript with NodeJS for my server. As part of the server logic, I need to manipulate .xlsx and .docx files, but they are not included in the Typescript compilation output. The .xlsx and ....
0
votes
0answers
24 views

Apache poi xlsx generation gets slow with many immages

I'm using apache poi 3.14 to generate an xlsx. Everything works correctly but there is a performance degradation after every image added to the workbook. The method slowing down is createPicture(...
0
votes
0answers
8 views

How to read data from a local XLSX file and save it into an Array/Object [duplicate]

I need to read data from a local XLSX file and save it to an object (or array). The data looks like this: and I need the data like this: so I can work with it (compare it to other objects/display ...
0
votes
0answers
13 views

How can I parse the array of the objects respective to their subcategory arrays from excel file using npm package xlsx?

how to can i parse the array of the objects respected to there sub categories arrays from excel file using npm package xlsx .... i have tried the following code but it doesn't meet the goal of ...
0
votes
2answers
81 views

How to create pandas dataframe from a list of python dictionaries?

I am looking for a way of creating a pandas DataFrame and then add it in an excel file using pandas from a list of dictionary. The first dictionary has 3 values (integer) and the second one has one ...
0
votes
0answers
16 views

How to load and parse .xlsx file using fetch API and XLSX library

I'm importing these library: <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/jszip.js"&...
0
votes
1answer
37 views

How to read a currency symbol from an xlsx file in python using openpyxl?

I have an .xlsx file that contains the salary information of international workforce of an organization. I'm extracting some of the their details. All goes fine except for their salaries. The salary ...