Questions tagged [xlsx]
789 questions
1
votes
1
answer
579
Views
Format date with SheetJS
Thank you in advance for taking a look at this question! I am trying to use SheetJS to read a .xlsx file but am having some trouble with a column of dates that is formatted via Excel as Custom 'yyyy/mm/dd hh:mm:ss'. All of these dates show up as large float values.
Here is the code to read the .xls...
0
votes
0
answer
4
Views
I cannot set style of worksheet of xlsx document in angular
Whereas I can change the value of cells exc., I cannot set style of cells in typescript. When i try to change it, in excel there is no change. I read documents about it but i cannot find solution.
My code is like this:
var worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json);
var cell = { s:...
1
votes
1
answer
642
Views
Export to CSV file using 'xlsx' in angular2
I want to export csv file using 'xlsx' npm module but in documentation it doesnt show any direct method for that. I have a json output and i want to export it using 'xlsx' module.Please help me for doing that. I tried this way but not working
const CSV_TYPE ='text/csv;charset=utf-8';
const CSV_EXTEN...
1
votes
0
answer
84
Views
docx4j excel xlsx insert image on android platform
i am new to docx4j ,i have previously used apache poi to insert multiple images into excel xlsx on my Android app,due to Huge and heavy library size imposed by poi, i am looking for alternative. docx4j image inserting seemed to be much more complex than i thought after looking at the examples sampl...
1
votes
1
answer
810
Views
export from mysql database to excel file
I'm trying to export table from MySQL database to excel file using PHP it's working correctly but Arabic language words displays as strange letters I tried everyhting in the internet but nothing worked you can see my code and tell me what I can do pleeeeeeeeease I'm working on it for 3 days now :(
t...
1
votes
0
answer
31
Views
parse xlsx file add marker to map
In my code below I am trying to upload a xlsx file, the file contains Latitutde and Longitude data, which I want to display on my googlemap.
In the handleFiles function I am able to upload the xlsx file, then it reads the xlsx file into json array as result. I selected the Lat Long data from the re...
1
votes
0
answer
220
Views
How to write on XLSX file using Javascript Array
I need suggestion on how to make a XLSX file using (Javascript array or JSON) and Style Object. I am already using alasql for generating the XLS file. But on opening of that file some advisory message is coming (verify that the file is not corrupted...).
The code i am using is
$scope.items = [{name...
1
votes
1
answer
2.8k
Views
Can not find module 'xlsx' in angular
I want to import xlsx.
So, i install xlsx using npm install xlsx.
And import xlsx module. import * as XLSX from 'xlsx';
(Also I try import { foo, bar } from 'xlsx';)
And run this code with Angular cli. ng serve.
I use it.
Angular CLI: 1.6.1
Node: 6.11.3
OS: win32 x64
Angular: 2.4.10
... common, comp...
1
votes
1
answer
76
Views
R - How to generate a list of data frames and write them into excel with lapply
So this might be pretty nuanced, but the fundamentals I'm struggling with is: using lapply to filter a few main data frame to create a number of small data frames. Combining those small data frames (which are related because they share a filter) into a multi-sheet excel document.
I have these packag...
1
votes
0
answer
37
Views
Create multiple xlsx files with charts Python
I'm looking for a massive python code to create xlsx files from my csv data. I need a file for a Cliente and there I need all information about the Clienteas I show you down. The point is I need to separate the csv data in Cliente and run my code for each Cliente
Cliente Fecha Subastas I...
1
votes
0
answer
164
Views
PyDrive create xlsx file and upload it (Python)
Sorry for my english. I try create new file in google drive(xlsx) and set someting data. But i have error:
AttributeError: 'bytes' object has no attribute 'encode'
my code:
drive = DriveBox() # return pydrive obj
df = pd.DataFrame({'a': [1, 2], 'b': [2, 3]})
wb = Workbook()
writer = pd.ExcelWriter('...
1
votes
0
answer
1.2k
Views
Crystal Reports with Java
I am using Java to generate crystal reports locally -not on report application server- and trying to export to XLSX format.
but so far, I was only able to export to xls format.
does the java library for crystal reports support xlsx format?
Edit 2018-02-02
if possible, I want the file to be saved dir...
1
votes
2
answer
238
Views
Modifying existing XLSX with Macros/Graphs with Node
So I am trying to insert a couple rows into an excel document that has graphs and macros.
However, it seems like xlsx and node-excel parses out the excel before writing so all of the information regarding styling, graphs, and macros get lost.
Does anyone know if its possible to accomplish this with...
1
votes
1
answer
212
Views
saveWorkbook in the xlsx package doesn’t let me to save the sheets that I created
I am using the package ‘xlsx’ in R to create and save an Excel file with several sheets. You can see below how I create and save the file. However, it is not working most of the time. It gave me the following error:
Error in .jcall('RJavaTools', 'Ljava/lang/Object;', 'invokeMethod',
cl, :
org.a...
1
votes
0
answer
70
Views
Roo spreadsheet parse exact header match
I have a spreadsheet(.xlsx) where two columns have the headers 'Auction Status' and 'Status';
When I run:
rows = sheet.parse(auction_status: 'Auction Status', status: 'Status')
both columns contain the values for the 'Auction Status' value. My guess is that parse is finding the string 'Status' insid...
1
votes
0
answer
368
Views
How to make the datetime column shown correctly on the ms excel?
I was using below api to generate the excel file.
var ws2 = XLSX.utils.json_to_sheet(dataForSheet, {skipHeader: true});
In the createtime column, only the date was displayed by default. Only when I click the cell, the datetime will be displayed. How can I resolve this issue? I hope the time displaye...
1
votes
0
answer
27
Views
xls-parser returning an empty object after parsing a non-empty file
I'm using xls-parser to parse a csv file. I'm calling the onFileSelection API of the parser in handleFileChange event of FormControl component. But, I'm getting an empty object every time as a response from this API.
Code:
'use strict'
var xlsParser = require('xls-parser');
handleFileChange(event) {...
1
votes
0
answer
264
Views
Can I configure git to unzip xlsx files prior to diffing them?
Related How to perform better document version control on Excel files and SQL schema files
That SO question led me to this blog: https://tante.cc/2010/06/23/managing-zip-based-file-formats-in-git/
Which suggested I make these changes to a couple of git files in my repo:
✗ cat .gitattributes...
1
votes
2
answer
270
Views
Efficient way to Identify xlsx & csv files in a directory, which contain specific string in the data
For GDPR purposes, I am trying to identify all spreadsheets within a directory, containing specific strings in the data.
The following code has worked on small files, but takes too long to be practical with any larger spreadsheets (1000+ rows).
It's worth mentioning that I don't know which columns t...
1
votes
0
answer
16
Views
openpyxl - “unexpected keyword argument 'WindowHeight' ” while opening a XLSX File
I'm trying to simply open a file with openpyxl but it gives me an error!
I really need to solve this! Thanks for any help
1
votes
0
answer
137
Views
TypeError: Cannot read property '0' of undefined in 'XLSX.read()'
I am using XLSX npm module and getting this error. I am also using fetch and retrieving the xlsx file and returning the buffer. I think I could be doing something wrong in that instance, but not for sure. Here is the code below.
const fetchSheet = async () => {
await connectToDatabase();
const store...
1
votes
0
answer
208
Views
Python: Insert an object into .xlsx file
I'm using Python 3.5 and xlsxwriter to create reports in excel, These reports require to have outlook .msg files embedded in the excel rows (which is usually done by adding them as 'objects' in excel, just like you would do with a .pdf file for example)
example of object in excel:
Unfortunately xlsx...
1
votes
0
answer
330
Views
“Warning: Could not start Excel server for export. XLSWRITE will attempt to write file in CSV format. > In xlswrite (line 174)
i have problem with my code that i try to save data in to excel format. i run matlab under linux. why everytime i try to save data into ecel format warning always show and myfile ist not excel file but .csv file, the meessage is
“Warning: Could not start Excel server for export. XLSWRITE will att...
1
votes
0
answer
51
Views
Ember user upload excel to csv - blank
With ember I am currently letting the user upload files through the ember-file-upload package and trying to parse excel files with the xlsx package but I can't seem to get them to work together. I have gotten other packages to convert the file to csv, json, etc. but can't seem to get the excel file...
1
votes
1
answer
51
Views
OpenXML and c# error to insert datatable in sql server
I have a C# application which serves to recover data from .XLSX file and insert the data to SQL server table.
For example I have a datatable with Identity and 3 columns.
When i execute SQL command. I have this error:
INSERT into an identity column not allowed on table variables. The
data for table-v...
1
votes
0
answer
127
Views
ggsave mac .png ignores size
On my Macbook Pro, early 2015, running High Sierra (if that matters) - it appears as though ggsave ignores my image width and height specification for .png files. I do not have this problem on machines running Windows. Here's a little reproducible example, although again, this issue will not occur i...
1
votes
0
answer
185
Views
fail to install R package xlsx
Since the newest version of xlsx is still in source format I used
install.packages('xlsx', type = 'source')
I have encountered the following issue when intalling xlsx.
Error : .onLoad failed in loadNamespace() for 'rJava', details:
call: inDL(x, as.logical(local), as.logical(now), ...)
error: unable...
1
votes
0
answer
46
Views
Split Multiline/Wrapped Cell Contents Into Separated Rows In Python
I have a data which consist of wrapped cell content
Wrapped data cell
My aim is to split the wrapped cell into multiple rows but yet retaining the UID through filling which identify the customer that buy the fruits and vegetables. To achieve something like this.
Multi-Row
Previously, I have tried u...
1
votes
1
answer
173
Views
Error loading properties of Java xlsx files. [ERROR] Malformed \uxxxx encoding
Can anyone help?
input = new FileInputStream(this.tmpFullFileName);
// load a properties file
prop.load(input);
When I try to load a xlsx file property.
[ERROR] Malformed \uxxxx encoding.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at su...
1
votes
0
answer
119
Views
How can we protect some parts of a sheet using rubyXL?
I'd like the user of my xlsx spreadsheet to edit some parts of a sheet but not the most of it. Or in other words, I'd like only some parts of the sheet to be protected.
I learned how to protect the sheet using rubyXL with the code below:
sheetProtection = RubyXL::WorksheetProtection.new(
password: h...
1
votes
2
answer
405
Views
Transfer data from R to a specific sheet and a specific range of an XLSX file
I am trying to transfer a matrix (or a data frame) from R to an MS xlsx file.
I know that the xlsx package does not provide a lot of options of pasting data to a specific range of an xlsx sheet (the only option I found is the addDataFrame function which is difficult to handle) and at the same time...
1
votes
0
answer
32
Views
ERROR in PYTHON type object 'Sheet' has no attribute 'add'
I have error in python code. I am trying split workbook to different sheets based on column value, below is the code.
import pandas as pd
import os
from xlwings import Book, Range, Sheet
path = ('C:\Dell')
worksheet = ('FILE.xlsx')
sheet =('Temporary_Table')
column = ('SERIAL_NUMBER')
workbook = os...
1
votes
0
answer
19
Views
exporting alphanumeric data to excel
I have troubles with formatting after exporting the data frame into excel. I calculate the data and then I use masking formula, to hide some data (using -- signs) if the sample is too low:
ValStat
1
votes
0
answer
200
Views
FlexCel created corrupted xlsx file
I use the FlexCel library to create an Excel report in the .xlsx format.
When creating a file in .xls format - everything works fine.
When I try to create a file in the .xlsx format, the file is created, but when I open it by Excel, I get an error that the file is corrupt and can not be opened. And...
1
votes
0
answer
186
Views
Determine if a file is a zip file or an .xlsx file
Based on this answer and another I can't find at the moment, I've built a function in Scala to determine if a given file path is a zip file or not. Apparently, the headers of zip files are signed with a specific set of magic numbers if they are an archive file.
My basic functionality for where I ne...
1
votes
0
answer
68
Views
Export xls or cvs data Angular 5
Hi I need export the data of a table in angular5 I'm using the API xls and filesaver this my code:
import { Injectable } from '@angular/core';
import * as FileSaver from 'file-saver';
import * as XLSX from 'xlsx';
const EXCEL_TYPE = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;...
1
votes
0
answer
277
Views
Error read_xlsx (v1.0): Error in read_fun(path = path, sheet = sheet, limits = limits, shim = shim, : std::bad_alloc
I have Rstudio Version 1.1.447/R 3.4.4 on my Mac and have been running this code with no problems in my script:
NCBI16S
1
votes
1
answer
618
Views
exceljs writes the file correctly in csv format, but the file is corrupted for xlsx format
This is my code for writing and downloading excel file using exceljs.
const excel = require('exceljs')
const tempfile = require('tempfile')
var workbook = new excel.Workbook()
var sheet1 = workbook.addWorksheet('sample')
sheet1.columns = req.keys // Some data
var tempFilePath = tempfile('.csv')
wo...
1
votes
0
answer
38
Views
HTML / Javascript - Specifying a local file to be used instead of upload using input file field
First of all many thanks for the precious help this community provides to newbies and experts in the field.
I'm currently developing a tool that parses an XLSX file and outputs the tables into the HTML.
At the moment I'm using a script provided by Catamphetamine: https://catamphetamine.github.io/rea...
1
votes
0
answer
29
Views
using xlsx package to overwrite a cell reference in xlsm file
I have a .xlsm workbook that has a cell B1 that is currently referencing to Cell B2, which has a hardcoded value is 5.
I'd like to use R to remove the reference from cell B1 and replace it with a hardcoded value of 0.
I'm attempting to do this in R by using the xlsx package. However, after using t...