import-from-excel Questions
11
Solved
I need to read from and write to Excel spreadsheets using Delphi 2010. Nothing fancy. Just reading and writing values from specific cells and ranges on different sheets. Needs to work without havin...
Longshoreman asked 17/3, 2010 at 19:13
7
Solved
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 &...
Hahn asked 4/9, 2015 at 13:32
10
Solved
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?
imp...
Ernaernald asked 27/2, 2015 at 13:21
11
Solved
I am trying to import data from excel file to SQL Server table. I am getting this error "External table is not in the expected format (Microsoft Office Access Database Engine)"
I am using Microsoft...
Beneath asked 23/4, 2015 at 20:48
9
Solved
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...
Expertize asked 23/7, 2010 at 18:9
8
Solved
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 d...
Moazami asked 20/1, 2015 at 15:21
7
Solved
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 i...
Ambary asked 4/3, 2015 at 17:16
2
To import an entire sheet of data from another spreadsheet using IMPORTRANGE I'd do something like this:
=importrange("google-drive-id-for-spreadsheet","A:AR")
This works fine ...
Virtuoso asked 14/1, 2018 at 13:52
4
I have a basic question about importing xlsx files to Python. I have checked many responses about the same topic, however I still cannot import my files to Python whatever I try. Here's my code and...
Stimulant asked 14/5, 2017 at 13:37
4
Solved
Can we use column headers to specify the column number from which we are parsing the excel sheet using roo gem? My current code is like this now:
oo = Openoffice.new("simple_spreadsheet.ods")
oo.d...
Bissell asked 20/7, 2011 at 17:44
6
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' );...
Noh asked 20/6, 2012 at 12:32
6
Solved
I am new to react JS. I am trying to perform uploading Excel sheet file using react.js and display data to a table. I got
partial reference from the link but, it is not complete. Please help with ...
Eachern asked 28/6, 2018 at 13:40
2
I have resource strings for various languages collected into a large excel sheet. Is there a tool to convert the strings for each language into .NET resource files (resx)?
-pom
Shogunate asked 14/6, 2011 at 9:49
25
Solved
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 ha...
Sennit asked 16/7, 2009 at 18:23
3
I am trying to import the data in my Excel file into R using Openxlsx library:
library(openxlsx)
data <- read.xlsx("datafile.xlsx", sheet = "Sheet1")
However, I get the foll...
Fellers asked 9/3, 2021 at 9:11
3
I read a large Excel file into pandas using .read_excel, and the file has date columns. When read into pandas, the dates default to a timestamp. Since the file is large, I would like to read the da...
Byword asked 23/2, 2016 at 13:37
4
Solved
I am trying to import data from excel to Sql Server using Import wizard. Everything seems fine in the first steps. The wizard is able to read the excel file and properly identify columns. But in th...
Genesa asked 15/9, 2011 at 15:24
4
Solved
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 straigh...
Ruben asked 13/11, 2010 at 0:51
2
I have a Excel file in .xlsx format. I have stored data by merging cells to form various columns. I am reading the Excel file via a Java web application and saving its data to a database (MySQL). B...
Solutrean asked 16/4, 2015 at 3:45
2
Solved
I'm running SQL Server 2012 on a 64bit Windows Server 2012 R2.
I don't have MS Office installed.
I now notice that when I start Start->Program Files->Microsoft SQL Server 2012->Import and Export Da...
Projector asked 20/5, 2015 at 20:10
1
'I have an excel file which contains many columns with strings, but i want to import certain columns of this excel file containing 'NGUYEN'.
I want to generate a string from columns in my excel whi...
Diazotize asked 15/10, 2017 at 5:24
1
Solved
Goal:
Import, transform / prep, and animate a coronavirus dataset from .xlsx using only R.
Text from Reproducible Error:
Error in seq.default(range[1], range[2], length.out = nframes) : 'from' m...
Pauiie asked 26/5, 2020 at 20:29
7
Solved
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 ShortDescri...
Subset asked 25/12, 2011 at 9:36
8
Solved
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 insufficie...
Garman asked 19/2, 2009 at 1:53
2
Using openpyxl I tried to read from the fifth line for some files. The files' first four lines are the header. Then the main content has a different format from the header. And I tried the method:
...
Milkwort asked 8/3, 2015 at 17:6
1 Next >
© 2022 - 2024 — McMap. All rights reserved.