Questions tagged [xlsx]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
13 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 ...
0
votes
0answers
17 views

Print excel file using CUPS_PDF in Mac

I want to convert many excel files to pdf. I found that I may be able to use CUPS_PDF driver to print to PDF. For example, lpr -P CUPS_PDF test_2.xlsx. However, whenever I typed this command, I just ...
0
votes
1answer
50 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 ...
0
votes
0answers
309 views

How to make xls table to one column

I have 100 columns in my spreadsheet, 100 rows each and I would like to combine them into a single 10 000 row column. How would I do that, without copy-pasting the columns manually 100 times?
0
votes
1answer
66 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 ...
0
votes
1answer
222 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 ...
-1
votes
2answers
101 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. ...
0
votes
0answers
90 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
1answer
453 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 --...
0
votes
0answers
22 views

Problems when an excel file is saved as .csv file [duplicate]

I have an excel (.xlsx) file , with only one sheet. This sheet have only 2 columns. All the cells in both columns are formatted as Text. The columns have this format : Name........Phone number Name1....
0
votes
1answer
1k 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 ...
1
vote
1answer
4k 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
0
votes
1answer
61 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
vote
1answer
748 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 ...
-2
votes
1answer
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 ...
3
votes
1answer
5k 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 ...
0
votes
1answer
12k 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 ...
0
votes
0answers
306 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?...
16
votes
3answers
110k 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. ...