Questions tagged [xlsx]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

Saving converted files (xls to xlsx) to a specific destination folder

First of all, say that I have no experience or knowledge on Visual Basic... I need to create a VBA macro to convert files from XLS to XLSX and then save the converted files to a specific folder. I ...
0
votes
0answers
20 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 ...
0
votes
2answers
97 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 ...
0
votes
1answer
28 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
vote
0answers
10 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 ...
0
votes
0answers
45 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 ...
0
votes
0answers
35 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
0answers
44 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 ...
0
votes
0answers
25 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
1answer
34 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
1answer
151 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
1answer
251 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
342 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
242 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
104 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
722 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
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
5k 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
64 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
919 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 ...
6
votes
1answer
6k 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
14k 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
331 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?...
18
votes
3answers
130k 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. ...