All Questions
1,307
questions
0
votes
1
answer
62
views
Writing to a cell in a XLSX file using Sheets Script
I'm using Google Sheets Script and would like to write data to a XLSX but preserve the XLSX file format so other applications can read it. I have tried the following without success. When I open the ...
- 33
1
vote
1
answer
31
views
Check cell type using xlsx package
I have an excel file like this:
I use xlsx to parse a sheet's data to json:
import * as XLSX from 'xlsx';
const wb = XLSX.read(data, { type: 'binary' });
const ws = wb.Sheets['Sheet'];
const json = ...
- 543
0
votes
0
answers
15
views
Date Object dont recognize a string using XLSX
I'm using XLSX package to read an excel file and for some reason some Date Objects are Date and others are string.
I'm using this line to define cells as Date type.
const workbook = XLSX.read(buff, {...
- 56
-1
votes
1
answer
31
views
Get column width of an excel speadsheet with a Perl module on a Linux system
While I'm able to create a XLSX file with Perl module Excel::Writer::XLSX and set a column's width, I can't find a way to get the width of a column in a spreadsheet of a XLSX file. I've tried ...
- 1,305
0
votes
0
answers
35
views
Excel Conditional Formatting Not Formatting
I'm trying to get a cell to fill green if the formula:
=IF(VLOOKUP(E5, Table3, 3)>VLOOKUP(E5, Table3, 4), TRUE, FALSE)
is true. When the formula is put in a cell, it returns true, but when ...
- 5
1
vote
1
answer
54
views
Excel Defined names and cell evaluation order causes unexpected behavior
I generate an excell sheet using Apache POI including 3 defined names used as the data for a graph.
This all works very nice except in a wierd edge case.
I have a column Categories where the user can ...
- 169
0
votes
1
answer
27
views
Trouble with MATLAB reading in excel cells with numeric and alphabetic values of differing lengths
I am working with MATLAB, and I am using data from an excel file. For my stations names I am having trouble reading in the data. EX: row in excel example I need it to accept when some have A at the ...
1
vote
1
answer
70
views
Exchange information between Solidworks and Excel back and forth using VBA
I want to communicate parameters between Solidworks and Excel (.xlsx) back and forth using VBA macros. Currently, this is what my Excel looks like:
For now, my script inserts the A2 and B2 values ...
- 59
0
votes
0
answers
54
views
Excel edit using Typescript
I am making a website in NextJs, the software is to generate an Excel with information about an invoice.
I have an Excel (Template) with the structure and styles of the Excel that I need to update ...
1
vote
1
answer
69
views
How to sort worksheets by name in a PhpSpreadsheet workbook without disrupting sheet indices?
I'm currently working with PhpSpreadsheet to generate evaluation reports in .xlsx format. These evaluations are categorized (e.g., Evaluation A, Evaluation B, etc.), and I need to group all similar ...
- 11
0
votes
0
answers
45
views
Preserving Markdown Styling in XLSX Generation
I am attempting to generate an XLSX file from a JSON object, where one of the fields contains Markdown text. While generating the XLSX file, I want to preserve the styling present in the Markdown text....
0
votes
0
answers
23
views
Change size of shape XML for excel XLSX
I want to change the size of a comment created for a Excel XLSX using XML.
First we are adding the comments, and then the shapes, this is the code generated for the shapes:
<?xml version="1.0&...
- 853
0
votes
1
answer
33
views
C# Form to OfficeOpenXMml file I/O writing error
I am trying to create and write to a xlsx file from a c# form.
private async void saveButton_Click(object sender, EventArgs e)
{
//variables are pulled from the form on save button click
...
- 35
0
votes
0
answers
25
views
xlsx to pdf using pywin32 unable to save pdf
I am trying to save an excel sheet by opening the file in excel with the pywin32 package. The file will open, however it crashes when trying to save as a pdf. My hunch is it is a printer issue of some ...
- 1
0
votes
0
answers
56
views
convert XML into xlsx
I'm trying to convert an XML into xlsx using the following code in python:
with open(str(Path.cwd())+'\test.xml', "rb") as f1:
with open(str(Path.cwd())+'\test.xlsx', "wb") as ...
- 285