All Questions
5,234
questions
0
votes
0
answers
35
views
Why does csv consider data in one column to be an empty string
I have a powershell script, which basically takes an xlsx file with data, converts it to csv and then fills certain cells in another (template) xlsx file with values from certain columns. There are ...
- 133
0
votes
1
answer
90
views
Is there a way to choose which cell/column of a CSV to upload a dataframe into, just like scraping data onto an excel file?
I have had experience with webscraping data onto excel files, and I know that when copying data down into an excel spreadsheet, you can choose which column to copy it into. (startcol = 10 as shown in ...
- 153
0
votes
2
answers
65
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 ...
- 5
0
votes
0
answers
44
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
48
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
21
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
62
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
16
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
111
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
83
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
62
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