All Questions
Tagged with spreadsheet csv
94 questions
-1
votes
1
answer
46
views
Looking for some ideas with how to reformat spreadsheet type data (excel, easymorph, etc..) [duplicate]
I have spreadsheet data in the following format:
example
Any row that has MULTIPLE 335xxxxxxx numbers separated by commas, I need to change into separate rows with a single 335xxxxxxx number. So lori ...
- 1
0
votes
1
answer
109
views
PyUno and calc/spreadsheet: how to export single sheet to csv?
I need to automate some spreadsheet manipulation and exporting via PyUNO, but I'm struggling on exporting a single sheet to CSV.
I made a simple shell script that first launch LibreOffice to open a ...
- 2,994
1
vote
1
answer
101
views
Perl: force Spreadsheet::Read to use Text::CSV_XS
I have an 8MB CSV file. Using Spreadsheet::Read it takes 10 seconds to read:
my $book = ReadData ( 'file.csv' );
my @rows = Spreadsheet::Read::rows($book->[1]); # first sheet
foreach my $i (2 .. ...
- 1,530
1
vote
1
answer
60
views
How to apply array formula to join all the cells in a column and exclude empty cells in google sheets doc spreadsheet
=ArrayFormula(join(",",char(34)&E3:E11&char(34))) This is the formula I have thus far.
It is able to output the values from the ranges I have manually chosen E3 to E11 which are
...
- 29
0
votes
1
answer
174
views
Parsing a CSV from a Mail (Gmail) with double quotes and ? characters with Google Apps Script
I did set up routines with the following code to parse CSVs into specific spreadsheets:
function updateGmvAndNmv() {
const threads = GmailApp.search("from:([email protected]) subject:(uniqueHeader)...
- 25
0
votes
1
answer
2k
views
How to display a spreadsheet/csv file in a website with react
I am trying to display a spreadsheet or a CSV file on a website using react.js
The files are uploaded on the website and I just want to display the files inputted to the website. I have tried the ...
- 57
0
votes
1
answer
115
views
Incrementing time shows #VALUE! error in Microsoft Excel
I am trying to increment time by 15 minutes. When I use the formula on a cell having (DD-MM-YYYY HH:MM:SS) 01-01-2022 01:00:00, it shows #VALUE! error. The calculation steps show the following
How to ...
- 164
1
vote
1
answer
572
views
Excel: How to increment time once in every 1000 rows
I have a date-time column in DD-MM-YYYY HH:MM:SS format. I need to increment this column value by 10 minutes once in every 1000 rows. Once an increment has been done, the value will remain constant ...
- 164
0
votes
1
answer
40
views
Timesheet Export
I need to export data out of excel worksheet into a CSV format with certain headings, etc. I need this to be user friendly, as it's for timesheets, ideally a button on the spreadsheet would be ideal, ...
- 3
1
vote
1
answer
152
views
Automating font color selection of specifc text in spreadsheets?
I have extracted data from a website and formatted it into a CSV, all with Python. My job requires me to check this data and to make it easier I'd like to have the string in column A be used as a ...
- 13
1
vote
2
answers
112
views
Can't convert array and display as csv
I am trying to read in a txt file, convert it to csv and display it in a spreadsheet. There are many example here and I have tried many of them but the result is the same. I seem to have two problems. ...
- 854
1
vote
3
answers
912
views
How to count the number of occurrences on comma delimited column in Python Pandas
How can to count the number of occurrences of comma-separated values from the whole list of columns
data frame is like this:
id column
1
2 1
3 1
4 1,2
5 1,2
6 1,2,4
7 1,2,4
8 1,2,4,6
...
0
votes
1
answer
372
views
Is there a way to populate an ObservableCollection in Xamarin.Forms by reading a csv file?
I have a Student class below, and I am using an ObservableCollection in the ViewModel class to display students in a ListView. Is there I can read from a csv/spreadsheet to fill the ...
- 3
2
votes
2
answers
1k
views
How to convert a paragraph html string to plain text without html tags in google app script?
this is a follow up question from my previous question. I'm having trouble when I want to convert HTML strings to plain text without HTML tags in google app script using the reference in this question....
- 73
1
vote
3
answers
4k
views
What's the cell limit of the importdata function in Google Sheets?
I'm trying to import a .csv file into a Google Sheet, but keep getting the message "Error Resource at url contents exceeded maximum size.".
When manually importing, I get 8498 rows and 112 ...
- 11