All Questions
Tagged with export microsoft-excel
52
questions
1
vote
0
answers
59
views
How can I save each non-empty cell of an Excel file as a separate .txt file? (e.g., 10 non-empty cells would result in 10 .txt files)
How can I save each non-empty cell of an Excel file as a separate .txt file? (e.g., 10 non-empty cells would result in 10 .txt files)
I use MS Excel 2108 on Windows 10.
- 21.8k
0
votes
1
answer
145
views
How to get text glow to properly export to SVG?
I have an Excel chart with some color regions and Black text over them, and I use a "glow" effect, with White color for the glow, to differentiate them from the background. So far, so good.
...
- 9,852
1
vote
2
answers
1k
views
How can I export data without "Save As..."?
I have some data in an xls file. I want to export it to csv. I don't want to save the file as csv, I just want to export it so I don't have to then go back and "Save As..." the original ...
- 5,181
1
vote
0
answers
197
views
Jira -- export tempo timesheet (grid view) to Excel
Jira: How do you export tempo timesheet (grid view) to Excel -- either .csv or an ordinary excel file.
I am using Microsoft Edge browser, and there is no easy link available (such as Export).
I ...
- 243
1
vote
0
answers
61
views
Graphic in Excel file deleted when exporting data from R when the graph has additional text
I have trouble when exporting data that I have created in R into an Excel file containing a graphic with additional text.
The problem is relatively specific as it does not happen without the ...
- 125
0
votes
1
answer
1k
views
Form Control Button to Export Worksheet to CSV While Excluding First Row
I have a workbook that has 4 worksheets. The first worksheet gets populated and then the other 3 worksheets are populated from the data in the first through formulas. I have to export the 3 worksheets ...
- 3
0
votes
0
answers
829
views
How to export Access database table exceeding 4 million records to Excel?
I have an Access database with 1 table with over 4 million records. I would like to read this in with Python, but the pyodbc module is giving me issues. Another approach I'm considering is to export ...
- 101
0
votes
1
answer
215
views
O365 - Export of total number of licenses
Do you know how to export via PowerShell from O365 total number of licenses with following parameters ?
change SkuID to friendly name
number of active licenses
number of used licenses
if possible, ...
- 1
0
votes
1
answer
3k
views
How can I successfully save JPGs that are embedded in Excel rows and subsequently transfer that file to another location?
Title is a bit confusing, I'll admit, but it's because I've never encountered this problem before and it's further complicated by the fact that I'm dealing with this person remotely and their computer ...
- 1
0
votes
1
answer
882
views
How to export/update CSV file through Excel Macro?
Thanks in advance for any help!
I have a file that produces an output table that also contains a unique key for the set of data. I want to be able to export this data into a CSV file.
That is easy ...
- 1
1
vote
1
answer
666
views
How to export tabular data from html to excel without columns merged
I have some data in rows and columns (thousands of entries) in html file which I want to export or copy/paste into an excel file. When I do that the three column data in excel file becomes two column (...
- 13
0
votes
1
answer
58
views
data export from site is in lines, how to put it in table form
I exported some data from a nutritions tracking website to use in excel and eventually in SPSS for analysis. However the data is exported in lines/rows. I need it to be in table form so I can use it ...
0
votes
0
answers
1k
views
Set Custom Path While Exporting in VBA
I am using this post's accepted answer for one my exports.
Based on the answer, it saves my exported .csv file in my C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART.
However, I need this ...
- 101
0
votes
1
answer
1k
views
Import Excel Spreadsheet Data into an ASP.net webform form using VBA
I am trying to use Excel VBA to export data from a spreadsheet into an aspx online form and submit it.
Example: I have a spreadsheet with column A titled "NAME". The rows are populated with the ...
- 13
2
votes
2
answers
3k
views
DQL/SQL to Excel - obtain results of multiple SELECT statements in spreadsheet
I wrote T-SQL query that contains few separate SELECT statements.
Each SELECT statement returns different number of columns and represents different properties/features, so that I don't want to join ...
- 165