Super User
Super User

Questions tagged [xlsx]

.XSLX is the file extension of the new Microsoft Excel file format.

.XSLX is the file format of the new Microsoft Excel file format which was introduced with the Microsoft Office Open XML file formats series which became wide-spread since Excel 2007.

25 questions
18
votes
3 answers

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. Automated naming of them isn't necessary. Does…
eichoa3I
  • 1,532
8
votes
2 answers

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 renaming the .zip extension back to .XLSX but then…
Jeremy Thompson
  • 1,286
  • 1
  • 13
  • 24
2
votes
2 answers

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 change the contents as represented when reopened…
bjornte
  • 167
1
vote
1 answer

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
jes516
  • 145
1
vote
1 answer

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 every column that it goes over. To illustrate,…
user1641165
  • 157
1
vote
0 answers

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 able to read data in each row and column but fails…
itgeek
  • 111
1
vote
1 answer

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 every day, yet for some reason every 24th hour…
Zain Raza
  • 13
1
vote
1 answer

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 (XLSX) in en-US as "2/7/2019" (Feb 7th 2019) e.g.…
user10989928
  • 11
1
vote
1 answer

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 get to 100MB)- when i gets deleted the files…
pbaup
  • 11
1
vote
1 answer

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 --force --overwrite --output OutputFilename I am…
user1193339
  • 11
0
votes
1 answer

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 default language but i still have the same problem…
JV_MISR
  • 1
0
votes
1 answer

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 size paper width with infinite pages tall. It uses…
Kim Stacks
  • 625
0
votes
0 answers

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?
BigCAT41
  • 13
0
votes
2 answers

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 than having my attention flitting back and forth…
Julius Hamilton
  • 227
0
votes
0 answers

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 awkward, inflexible, doesn't scale, etc etc. I am…
pateksan
  • 201
1
2