Questions tagged [excel-reader]
37 questions
5
votes
1 answer
Does ExcelDataReader for C# require Excel to be installed on the target machine?
Does ExcelDataReader for C# require Excel to be installed on the machine the C# code is executing on?
Some packages (such as Aspose) explicitly state that they are independent of Microsoft.Office.Interop.Excel libraries:
Aspose.Cells for .NET ...…
Fractal
- 1,748
- 5
- 26
- 46
5
votes
1 answer
Looks like there is no Option fo me to set my First Row as Column Names when using the Excel Data Reader in Selenium C#
I am using the Excel Data Reader plugin to read and parse excel data, and I would like to set the "IsFirstRowAsColumnNames" to true then finding out that there is no such definition for my created IExcelDataReader object. See the "XXXXXXXXXX" from…
J.FromHeaven
- 343
- 3
- 9
3
votes
1 answer
How to remove empty rows and extra columns from datatable
I have a process to import data from excel to DB using ExcelReaderFactory. But when there is empty rows/column, we are facing issue. Below is my original code:
IExcelDataReader excelReader =…
user1926138
- 1,464
- 7
- 34
- 53
2
votes
1 answer
get excel sheet row id using exceldatareader into dataset
I have chosen the ExcelDataReader Library for Reading the .XLS and .XLSX files using C#.
ExcelDataReader is perfectly working with both file formats with my local and deployment server environment.
I'm facing issue, how to get all the row id from…
Dinesh Patil
- 104
- 2
- 8
2
votes
2 answers
ExcelReader Factory Fails on last write line
I have an Excel file WKDEL.xls. I want to read all records and import them into an SQL Table I already created.
Example Excel file:
ID | FNAME | T_W_TON | Y_D_TON |…
ivias
- 249
- 1
- 3
- 15
1
vote
0 answers
Flutter Web how to read and write file (xlsx,txt etc)
I am trying to read the two files first one is a text file and the second one is an excel file. I'm using flutter web 2.10 but can't find a way to read those files. I have tried this method but it doesn't work now To read and Write File in Flutter…
Hassan Ali
- 158
- 8
1
vote
0 answers
unprotect password in JavaScript with XLSX.read Javascript API
Read I want when upload file excel (excel is protect with password) unprotect or remove the password with XLSX.read but don't unprotect or remove the password from excel file.
This my code:
amirnowrozian
- 305
- 1
- 2
- 10
1
vote
0 answers
Read and convert monthly grid excel file data in javascript
I tried to read monthly food menu from excel in javascript (actually .net core mvc project). But the excel template not usual, the excel data looks like a monthly, how can I parse and read this ?
hkyaaa
- 100
- 9
1
vote
1 answer
How to edit excel row values using c#
I'm importing the excel files using import button and displaying them in the datagridview.
Now when i click at apply button, i want the first letter of the row values(highlighted in the attached image) to be capitalized (there can be multiple…
h3r
- 43
- 1
- 1
- 7
1
vote
1 answer
How do I get the project Excel path
In my project I have Test Data folder and inside that I have my xlsx file.
I am trying to get the project path folder so it read from their instead of hard coding the path. But it always goes and reads form project/bin/debug path. Here is my Excel…
Johnny_347
- 53
- 1
- 7
1
vote
1 answer
Reading a specified number of rows in huge excel file
I want to read a huge excel file in patches so as to reduce reading time.
I wrote the code below.
$xls = new Spreadsheet_Excel_Reader($path);
$dd=array(0);
for($row=2;$row<=10;$row++){
$val=$xls->val($row,$field);
}
This takes a lot of time each…
warda Jouria
- 63
- 4
1
vote
0 answers
Need to write numeric values in DBF File using ExcelReaderFactory
The code below is tested and writes a dbf file but the values are strings because i cannot seem to initialize or convert the values to doubles or floats before writing to the file. Can anyone assist and see how for example the first…
ivias
- 249
- 1
- 3
- 15
1
vote
1 answer
IExcelReader how to read date and insert it into sql?
I have in my excel some date fields that are in this format:
1/4/2016, 2/14/2016, etc.
When i try to insert that fields in a database I get an error:
String is not recongized as a valid DateTime
this is my code:
IExcelDataReader excelReader;
…
Alexander
- 405
- 7
- 17
0
votes
0 answers
where can we store excel sheet globally so that we can read the data by excel reader class?
I know about how we can read the excel sheet from the local system but i want to know about if there is an excel sheet which can handle by the organization which can be modified by others too where we can store that and how can we read the excel…
0
votes
1 answer
How to update text file from taking field values from excel file in python?
I would like to fetch value of BSNValue field from excel file and update the same BSNValue against the matching alert_name in corresponding text file.
Original Excel file
| Alert_Name | BSNValue |
|:---:|:---:|
| Alert_number_1 | SVS176 |
|…
Tarun
- 9
- 1