Stack Overflow
Stack Overflow

Questions tagged [import-from-excel]

Information taken from Microsoft Excel and imported in to another system

Information taken from Microsoft Excel and imported in to another system

733 questions
184
votes
20 answers

Import and Export Excel - What is the best library?

In one of our ASP.NET applications in C#, we take a certain data collection (SubSonic collection) and export it to Excel. We also want to import Excel files in a specific format. I'm looking for a library I can use for this purpose.…
Jason Kealey
  • 7,988
  • 11
  • 42
  • 55
168
votes
25 answers

Excel "External table is not in the expected format."

I'm trying to read an Excel (xlsx) file using the code shown below. I get an "External table is not in the expected format." error unless I have the file already open in Excel. In other words, I have to open the file in Excel first before I can read…
Sisiutl
  • 4,915
  • 8
  • 41
  • 54
114
votes
8 answers

Reading an Excel file in PHP

I'm trying to read an Excel file (Office 2003). There is an Excel file that needs to be uploaded and its contents parsed. Via Google, I can only find answers to these related (and insufficient topics): generating Excel files, reading Excel XML…
Dinah
  • 52,922
  • 30
  • 133
  • 149
81
votes
7 answers

Reading Excel file using node.js

Okay so i am using the FileUploader module to upload my file from angular to my REST API: var uploader = $scope.uploader = new FileUploader({ url: api.getUrl('uploadCompetence',null) }); This is sent to the following POST function: …
Marc Rasmussen
  • 19,771
  • 79
  • 203
  • 364
66
votes
7 answers

Text was truncated or one or more characters had no match in the target code page When importing from Excel file

I have an excel file with four text columns: one of them is called ShortDescription which has the longest value. I created a table in SQL Server 2008 database, with four columns and the ShortDescription column type is set to NvarChar(Max). but when…
Nour
  • 5,252
  • 3
  • 41
  • 66
58
votes
8 answers

Faster way to read Excel files to pandas dataframe

I have a 14MB Excel file with five worksheets that I'm reading into a Pandas dataframe, and although the code below works, it takes 9 minutes! Does anyone have suggestions for speeding it up? import pandas as pd def OTT_read(xl,site_name): df =…
jsignell
  • 3,072
  • 1
  • 22
  • 23
47
votes
9 answers

From Excel to DataTable in C# with Open XML

I'm using Visual Studio 2008 and I need create a DataTable from a Excel Sheet using the Open XML SDK 2.0. I need to create it with the DataTable columns with the first row of the sheet and complete it with the rest of values. Does anyone have a…
Rastro
  • 473
  • 1
  • 5
  • 7
46
votes
3 answers

How to export data from Excel spreadsheet to Sql Server 2008 table

I want to import data from an Excel file - assume Excel 2003 / .xls - to Sql Server 2008. Have tried adding a linked server to the JET OLE DB Access driver, and of course it fails on the 64-bit machine. But when I try to drop the linked server while…
Loser Coder
  • 2,338
  • 8
  • 42
  • 66
40
votes
6 answers

Could not load file or assembly 'Office, Version=15.0.0.0'

I use Vs2013. I have created application in which I use Excel file as an input and get contact from the file. Everything is working in my computer. I have Vs2013. Windows 8.1, Ms office 2007 & 2013. When I run my application in any other computer,…
NJ Bhanushali
  • 901
  • 1
  • 12
  • 21
35
votes
7 answers

how to import excel file (XLSX) to mongoDB

I have a set of data as input to be given to MongoDB in XLSX format. How am I supposed to import the Excel file as input to MongoDB? Is there any plugin available to import xlsx files as input to MongoDB?
SUNDARRAJAN K
  • 2,237
  • 2
  • 22
  • 38
33
votes
8 answers

Accessing Excel file from Sharepoint with R

am trying to write an R script that will access an Excel file that is stored on my company's Sharepoint page so that I can make a few calculations and plot the results. I've tried various ways to do this (download.file, RCurl getURL(), gdata), but…
jim616
  • 453
  • 1
  • 4
  • 6
27
votes
6 answers

Excel date conversion using PHP Excel

i am reading date from excel which is in this format 12/5/2012 day/month/year using this code to read . using PHP EXCEL PHPExcel_Style_NumberFormat::toFormattedString($value['A'],'YYYY-MM-DD' ); its working like charm converting the above…
Abdul basit
  • 307
  • 1
  • 4
  • 9
24
votes
4 answers

How do I read sheet two of an xlsx file with PHPExcel?

I know how to read my xlsx spreadsheet and loop through the first sheet. It has 5 sheets and I am having trouble getting to any other than the first. Here is the code I am using which was straight from the documentation. You can see I tried to…
Tom
  • 1,971
  • 3
  • 22
  • 32
22
votes
3 answers

Exclude first row when importing data from excel into Python

I have a partial code to import excel into Python as strings. How I can exclude first row when importing data from excel into Python? import pandas as pd data = pd.read_excel(".xlsx", parse_cols="A,C,E,G, I, K, M, O, Q, S, U, W, Y, AA, AC, AE, AG,…
Ajml
  • 379
  • 1
  • 2
  • 13
20
votes
1 answer

Help with a OleDB connection string for excel files

The problem i'm having is that the data adapter is looking at only the first row in each column to determine the data type. In my case the first column "SKU" is numbers for the first 500 rows then I happen to have SKU's which are mixed numbers and…
The Muffin Man
  • 19,585
  • 30
  • 119
  • 191
1
2 3
…
48 49