Import text (.txt or .csv) files. There are two ways to import data from a text file by using Microsoft Office Excel: You can open the text file in Excel, or you can import the text file as an external data range. To export data from Excel to a text file, use the Save As command.
Questions tagged [excel-import]
73 questions
14
votes
2 answers
How can i get actual used range for modified excels using Epplus?
I am reading data from excel to datable using EPPlus.
After reading an excel sheet with 10 rows of record, I modified the excel sheet by removing existing data and kept data for only one row.
But when I am reading the modified excel it still reading…
AcAnanth
- 765
- 3
- 19
- 53
4
votes
2 answers
Concatenating Firstname and lastname as Name and then ommit Firtname and LastName in SSIS
I have a problem statement as below :
From a DB source I have a table which has data related to Person. Out of which 3 columns are as Title, FirstName, LastName and I want to replace this as Name before actually putting it to the destination.
I…
Avineshkumar Tiwari
- 89
- 7
2
votes
2 answers
(PhpOffice\\PhpSpreadsheet\\Reader\\Exception(code: 0): Could not find zip member laravel queues job - Laravel
I have application created using Laravel 9.
i have installed 'maatwebsite/excel' library to export and import excel file. it is working good on local and server.
but now i have implemented laravel queue job to run process in background. and excel…
Kirti Umrigar
- 57
- 11
2
votes
2 answers
Date is appearing in number format while upload / import excel sheet in Angular
I am trying to implement uploading the excel sheet using angular but when the sheet is displayed in browser date is changed to number format. For ex. 12-12-2020 is changed to 44177.00011574074. I need it in dd-mm-yyyy format. Please guide me the…
Kartik Dolas
- 703
- 1
- 9
- 24
2
votes
1 answer
How to pass user_id for importing excel using Laravel?
I have a problem with excel import using Laravel.
The user wants import excel of suppliers data into database.
The suppliers table got user_id but the user may not have their own user_id. So, when importing excel file the user use excel without…
soe thein
- 61
- 1
- 8
2
votes
1 answer
Importing data from excel files in D3 js
I am working on D3 js collapsible tree layout, i want to know is there any way we can directly feed the data from excel file rather than using json object file?
Tiru
- 21
- 1
- 3
2
votes
1 answer
EPPlus import file xlsm
I am trying to import an xlsm file using EPPlus. I found the link that said EPPlus doesn't support this : Convert XLSM to XLSX . It's very old so I wanted to know if it supports it now ? If not, is there any way to do this with EPPlus by converting…
Ankur Garg
- 23
- 1
- 3
2
votes
2 answers
Import and display excel file in PHP from another directory. I want to read excel and display its conten
I want to import an excel file in PHP from another directory. I want to read excel and display its content but its in another diretory and I'm getting an error
Notice: Undefined index: file in F:\Xampp\htdocs\upload.php on line 3
import.php
Shakeeb
- 21
- 1
- 6
2
votes
1 answer
Is there any way to overcome limitations when importing from Excel in SQL Server?
I'm trying to import a large number of columns from an excel file: specifically, here are the ranges:
Biggest column name has 80 characters. When imported, SQL Server chops off anything after 64 characters. I'm not sure why, as the max length for…
LearnByReading
- 1,813
- 4
- 21
- 43
1
vote
0 answers
Can I Import Results From Excel Into Test Rail?
We have just started using Test Rail in our business. One of our user testers has extracted their Test Run into Excel and has completed all of their testing within the Excel document (don't ask I don't know why).
Is there a way - for a relatively…
Andy J
- 11
- 1
1
vote
1 answer
How to combine many properties into one List property in C#
I am a little bit confused about how to read data from Excel. I am trying to import Excel for updating product list, I create an Excel model; I added all basic properties like name, price, quantity, etc. into this model. I will read all Excel and…
Çağlar Can Sarıkaya
- 103
- 2
- 7
1
vote
2 answers
Import excel file to database using Laravel
why get undefined offset when importing excel file to the database using laravel.
UserImport.php
public function model(array $row)
{
var_dump($row);
return new User([
'name' =>$row[0],
'email'=>$row[1],
…
R.W.S. Maleesha
- 7
- 2
1
vote
1 answer
QueryTables problem with scientific notation
I'm trying to import data from a text file, there is no problem with that, the code runs and the data is imported but not correctly. I have text files with this type of numbers: 1.3309884e-13
When I'm importing the values, Excel is not taking the…
Mar
- 31
- 2
1
vote
1 answer
How can I use Excel to scatterplot more than 255 X-Y pairs from .csv file?
My XY data is converted to a category axis when I attempt to scatterplot more than 303 pairs; bogus data generated IN Excel (such as going to cell B3 and entering B2+1, then dragging that formula down to 1,000 rows, doing same in column C) will…
R. Wolford
- 11
- 1
1
vote
2 answers
Powershell imported date and time from Excel column are imported with wrong format
I´m importing a Excel document to a powershell script using Import-Excel module.
The import works great but the column with date gets formatted really weird.
The date and time in the Excel sheet are formatted like this: yyyy-mm-dd hh:mm (2020-09-01…
Markus Sacramento
- 334
- 5
- 21