Questions tagged [xlsx]
.XSLX is the file extension of the new Microsoft Excel file format.
25
questions
0
votes
2
answers
372
views
Is there a way to display just one cell of an Excel spreadsheet on screen at a time?
I have to review the quality of all the entries in an Excel document and I would find it a lot smoother and less of a mental load if I could just focus on the contents of one cell at a time, rather ...
- 157
0
votes
0
answers
28
views
How to get a conditional scale with with 4+ colours without VBA?
How do I achieve a conditional scale with with 4+ colours without VBA?
This is what I am trying to achieve:
The only way I know to achieve the above is by using two separate scales which is very ...
- 191
0
votes
2
answers
773
views
Changes to sharedStrings.xml in xlsx archive does not change Excel contents
The Excel file format .xlsx is on fact an archive that can be inspected, and have the contents edited, if renamed to .zip.
However, changes to the sharedStrings.xml file in the .xlsx archive does not ...
- 127
0
votes
1
answer
123
views
Excel Macro building: How do I pull .csv and .xlsx files from my downloads
I am working on a tool to help my business order products. Right now, We have a tool that pulls all of the .csv files from our downloads folder and add them to one excel work book.
I am trying to ...
- 1
1
vote
0
answers
17
views
read data from one file(.xlsx), write into another
I'm trying to read all rows and column's data from input.xlsx file , and insert into another file output.xlsx using python script (iterate through for loop).
Problem:
Using "for loop" in this script ...
- 111
0
votes
0
answers
162
views
How can one “split” an Excel (.xlsx) file that contains multiple sheets into separate sheet[n].xlsx on my Mac?
I want to acknowledge first before I ask this question that this question has been answered before here but I still cannot get it to work with my Mac. I see others had success in the thread mentioned ...
- 101
0
votes
0
answers
51
views
Excel media image name not match
Background:
I was trying to extract the image from PDF File, but I fail to do so,
I then convert the PDF file to .xlsx file, because I know I can just unzip the xlsx.
Question:
But I found out that ...
0
votes
0
answers
234
views
LibreOffice Calc copy/paste to Google Spreadsheets skips empty rows
The problem is in that, that when I copy selection range from LibreOffice Calc to Google Spreadsheet, the result are copied with empty rows missing. The row in the selection must have all cells empty ...
- 131
0
votes
0
answers
29
views
Excel Not Filtering Properly
I have an issue with a very large excel spread sheet with approximately 152,000 records. I have noted that when I try to filter by any column, the filter will organize it, but not remove extraneous ...
1
vote
1
answer
101
views
Certain Time Values in a .xlsx not Changing When I convert to a .csv
I am trying to convert from an Excel spreadsheet (.xlsx) file to a .csv file. The software I am using is Excel 2007. The issue I am having is I have a column of date and time values for every hour of ...
- 13
1
vote
1
answer
316
views
Excel (XLSX) and locales
Does opening an .xlsx file in systems with different locales correctly render the content according to locale, regardless of what locale file was originally created in?
e.g. User 1 creates excel file ...
- 11
0
votes
1
answer
497
views
Excel 2016 zipped folder - what is the content of XL>Drawings folder
i see a lot of Excel files that have problems with performance on good machines... the files are small - 1-5 MB.
When i unzip them there is always the folder "Drawings" in XL folder (unzipped they can ...
- 1
0
votes
1
answer
434
views
Converting a Windows xlsx into a Mac xlsx
I'm working on a process that takes data from customers and parses it into our product. In this case, an xlsx file. Unfortunately, our product is having trouble reading it because it was coded to read ...
- 56
-1
votes
2
answers
454
views
Inserting Header Row into Multiple Excel Workbooks
I'm regularly given a large number of single-sheet excel files (xlsx). They vary in the number of records, but they always have only five columns.
I need to insert the same header row into each file. ...
- 213
0
votes
0
answers
116
views
how to protect my excel workbook project code without using xlsx
Dears,
i have an excel workbook hello.xlsm , this workbook cantains many macros.
if i save it as hello.xlsx then the macros will disappear from the project and the project will fail.
if i keep it as ...
1
vote
1
answer
1k
views
XLSX files corrupted during encryption
I have a vendor encrypting an xlsx file using McAfee E-Business server with PGP version 7.1.1 using the following command:
pgp --encrypt --sign --user ${vendorpgpkey} --passphrase InputFilename --...
- 11
0
votes
1
answer
2k
views
Excel 2013 .xlsx files won't open
I am trying to open a file that I have created myself via a web API that I made for PHP. The file is created and downloads successfully but when I go to open it, I get this error:
Excel cannot open ...
- 103
1
vote
1
answer
8k
views
using powershell, is it possible to convert an XLSX file to XLS?
As the title states, is this possible? I found some scripts for XLS to XLSX, but not the other way around.
Can this be done with powershell?
Thanks
- 145
0
votes
1
answer
69
views
openoffice transfromed decimal separator for an xlsx file in server machine
i try to configure openoffice in linux server to use comma as decimal separator,i search and i found that have a relation with regional parametre so i configure etc/locales.conf to use french as ...
- 1
1
vote
1
answer
1k
views
Excel column headers export to csv
Just wandering how I can export excel files to csv while retaining the multicolumn headers?
I realize that csv does not support this however, I'm hoping that I can have the header name duplicated for ...
- 157
-2
votes
1
answer
2k
views
How to convert many .csv files into 1 .xlsx file with multiple tabs [closed]
I have multiple .csv files that need to be in a single .xlsx file, each on it's own tab. I know how to do it manually. is there an automated way do do this? I'm going to need to do this on a monthly ...
8
votes
2
answers
8k
views
Combine unzipped xml files back into a working XLSX file
I can rename an Excel file extension from .XLSX to .zip and extract
out the xml files.
How do I combine individual Excel xml files back into a single XLSX file?
I tried zipping up the folder and ...
- 1,265
0
votes
1
answer
15k
views
How to print two different sheets with different scale options using Excel 2007 and Excel 2010?
I have two sheets in a .xlsx file.
The first sheet uses columns A to C and fits into a single landscape orientation A4 size paper.
The second sheet will fit into a single landscape orientation A4 ...
- 567
0
votes
0
answers
332
views
automated conversion of xlsx to txt file
I need a way to automate a process where I would get a xlsx file in a folder and have it automatically converted into a tab delminited file (txt) file.What would be the best way to go about doing this?...
- 13
18
votes
3
answers
144k
views
How can one "split" an Excel (.xlsx) file that contains multiple sheets into separate sheet[n].xlsx?
I think the title says it all for this question but to elaborate a bit further:
I have a .xlsx file which contains a few dozen sheets. I want to output all of those sheets as separate .xlsx files. ...
- 1,492