All Questions
1,242
questions
0
votes
0
answers
27
views
VBA import .xlsx file into excel via web import [closed]
I'm rather new to vba and trying to write a code which imports a file via a weblink into my current excel. When I import the file manually via Data -> from Web it works fine and I merely have to ...
0
votes
0
answers
39
views
Excel legacy wizards disabled after importing txt file
I have a question with regard to the legacy import wizards in Excel.
Nowadays, in our company we work in Excel 365 and although I found the option to enable the legacy wizards under Options>Data, ...
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 ...
0
votes
0
answers
29
views
How can I resolve the "No ReaderType or WriterType could be detected" issue when importing an Excel file from S3 to a web server using PHP?
I am getting this issue on excel file import on web server. But this is working fine on local server.
No ReaderType or WriterType could be detected. Make sure you either pass a valid extension to the ...
1
vote
1
answer
50
views
Getting number values after Excel data import
I imported text from a text file that has text and numbers into excel using data import using text/csv import option. I used space as the delimiter. After the data is imported, the numbers have ...
0
votes
0
answers
37
views
Organizing DataFrames from several spreadsheets
I have several spreadsheets with tax data for each month. I organized them into folders labeled after each year (2009, 2010, etc.). Each folder contains 12 spreadsheets for each month.
There are two ...
0
votes
0
answers
31
views
How can i import xls files in python?
The xls file from excel 97-2003 like xml file.
I tried with pandas,xlrd, openpyxl and other ways. I couldn't import in python. How can i deal with?
Code=
import xlrd
wb = xlrd.open_workbook('...
0
votes
0
answers
23
views
Import product data(with variants and categories) from Amazon to Odoo
I have an Excel file containing Product data (with product categories with variants) exported from Amazon. the number of products/items in the file is more than 10000 (ten thousand). the problem is ...
0
votes
1
answer
34
views
How to get a websites data with the input from a cell Excel
I'm trying to make a excel workbook for a game called torn city. I want users to be able to input their game key into a cell and then excel automatically pulls the data from a link with the combined ...
0
votes
1
answer
66
views
Import a text file to Excel using VBA on the same sheet
I want to import a text file into the current Excel Sheet.
Code I found keeps the text as I want, however it opens a new Excel workbook and pastes it there. This isn't ideal since at times I'll have ...
0
votes
1
answer
61
views
I have a 7.9MM record CSV file to import into Excel. How do I read portions of the CSV file to subset the data?
I have a 53 variable, 7.9MM row CSV file to import into Excel. This exceeds the row limit for Excel. I would like to import a set of 8 files, each containing about 1 million rows from the CSV into ...
0
votes
1
answer
33
views
How to match fields sub_category_id in database with SubCategory in excel data when importing data excel to laravel?
I want to import excel data to laravel database, but in my database i have sub_category_id fields that refer to my sub_categories table, in my excel template the sub_category_id named SubCategory, the ...
0
votes
1
answer
37
views
Importing CSV Files into Excel based on reference list
I have an excel file which I have built to import all csv files from a given date (entered in by the user using a message box. This all works fine and as expected.
The change I would like to make is ...
0
votes
0
answers
32
views
Boost the performance when importing an excel to MATLAB
Given that I have a excel file with 101 Sheets, now I would like to import all the sheets to MATLAB.
My trial
tic
sheet_names = sheetnames('./data/head_101.xls');
n_rows = numel(sheet_names);
...
0
votes
1
answer
435
views
Import Excel file in flutter app for begginer
I'm contacting you to ask for help with Flutter. I'm new to using this language and I'm having difficulty with some of the logic.
I want to import an Excel file (placed in the assets folder) to ...