Questions tagged [xlsx]

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...
user
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...
Abanob William
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...
Candy
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...
Niraj Sazzie
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...
Jong-Hyen Kim
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...
R. Kersting
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...
Martin Bouhier
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('...
r1299597
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...
ahmad alzamer
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...
Vangogh500
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...
hamideh
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...
wuliwong
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...
liam xu
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) {...
Gopal Garg
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...
jcollum
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...
joseph stern
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
Bruno Freitas
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...
Taylor Austin
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...
Dantuzzo
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...
Fian Eka
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...
lildrizzle
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...
FranPN
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...
Kris Williams
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...
newbie
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...
Denova
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...
Hes
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...
Junjie
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...
Whitebeard13
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...
Taqwa Alhadidi
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
Emil Kosa
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...
Wizard
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...
NateH06
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;...
Juan Perez
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
Gina
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...
RINIEE
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...
Ângelo Cunha
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...
Tyler Law
1

votes
0

answer
24

Views

Assistance! Issue requesting data from XLSX

I'm getting this error: jquery-1.12.4.js:837 Uncaught RangeError: Maximum call stack size exceeded at Function.Sizzle [as find] (jquery-1.12.4.js:837) at jQuery.fn.init.find (jquery-1.12.4.js:2826) at HTMLTableElement. (datatables.min.js:101) at Function.each (jquery-1.12.4.js:370) at j...
Bebo Santana
1

votes
2

answer
28

Views

Excel sheet size reduced on resaving

I created an excel sheet with python xlsxwriter. When i resaved it with libreoffice calc the size decreased by more than 60 percent. why is it ? Is there any way i can mimic this in python to reduce my file size?
bakarin

View additional questions