All Questions
5,232
questions
0
votes
1
answer
46
views
Export sheet in a workbook to CSV file in the same location every week
I have a sheet in a workbook I would like to export to a csv file that gets updated every week.
So ideally, I want the VBA code to export whatever data is in the sheet and overwrite what was existing ...
- 3
0
votes
0
answers
39
views
Disregard Carriage Return or Line Break when Importing CSV with Macro
I am trying to import a CSV into Excel using a macro but some of the CSV data contains what appears to be CR Carriage Returns or LB Line Breaks. Instead of the CSV entry importing into the next one ...
- 65
0
votes
0
answers
42
views
How to import CSV in Laravel?
I want to make a CSV import using the maatwebsite/excel package. I have made the codes. And the data format that I want to import is as below:
Trans Date,Eff Date,Trans Description,Trans Code,Debit,...
- 407
0
votes
1
answer
20
views
Columns of Data missing on Google Sheet file after upload
I have this program that is supposed to take some csv files using pandas and convert them to google sheet files and upload them to my Google Drive folder. However, when uploaded, only the last 8 ...
0
votes
1
answer
57
views
How can I combine multiple CSV files into one Excel worksheet using Python?
I am trying to combine multiple CSV files into an Excel worksheet so I can analyse my data.
So far I have been able to create the worksheet with the names of the CSV files as the tabs, but in the ...
-1
votes
0
answers
15
views
SSIS - Excel Sheet to CSV
I have to import multiple xlsx files using SSIS. We can't install Excel on the database server we use to do the processing. I have a python script that will work but wanted to run automatically from ...
0
votes
1
answer
110
views
CSV file is treating commas in string values as delimiters and shifting data into wrong columns. Is there a way to fix this in R?
I have a large csv file that I pulled from an online database that doesn't seem to read well. It looks like it treats commas in a couple of the columns as delimiters and then parses the data into new ...
- 21
0
votes
0
answers
25
views
Why my office integration always save Excel to CVS with comma separator value?
I use Control Panel->Region, then click on "Additional Settings", then set List Separator to ; (semicolon) in the "Customize Format" dialog.
If I open Excel (without my office ...
- 1
0
votes
0
answers
27
views
MySQL select into outfile formatting for CSV
I'm trying to do a select into outfile to a CSV. My table values can contain characters like \r, \n, comma, "(double quotes)
Now MySQL does not seem to handle all the above characters efficiently
...
- 265
0
votes
1
answer
30
views
Duplicate CSV row, changing a cell value
TL:DR
For every permission Space in my CSV (below) that grants permission to the RBAC group ABC, I need to duplicate the row and grant the same permission to RBAC group XYZ.
The long version:
I have a ...
0
votes
0
answers
82
views
How to keep data frame data types when exporting to CSV file? [duplicate]
I have a pandas data frame with int64 , string[python] , and float64 data types. How do I preserve those data types when exporting pandas DataFrame.to_csv option?
I need the exported Excel file to be ...
0
votes
1
answer
61
views
How to copy all the data from a CSV (starting from row 1) over to an existing Excel file?
My script copies data from a CSV file located in a local folder over to a file located in a shared drive folder. The problem I am having is that the CSV does not have headers, it is all data which ...
1
vote
0
answers
48
views
Request help marrying two VBA scripts together (Find/Replace)
Attempting to add Find/Replace to existing code
Starting with this piece of code which works to convert a .CSV to an .XLS File:
Sub CSVtoXLS()
'UpdatebyExtendoffice20170814
Dim xFd As FileDialog
...
- 11
0
votes
0
answers
49
views
Copy data from multiple CSVs to worksheets of the same names in a master workbook
I'm trying to consolidate data from multiple csv files into a master workbook where each sheet matches up with each CSV file. The csvs are outputs from an analytics system. The names of the csvs will ...
0
votes
2
answers
77
views
Greek letters in Rstudio, and exporting to csv
I'm reading data from pdf files that contains Greek letters, and it imports as unicode. I want it to:
a) display correctly as Greek letters in RStudio, and
b) maintain the correctly formatted Greek ...
- 331