Questions tagged [excel-reader]
37 questions
0
votes
1 answer
How to read Excel(.xlsx) file in php(codeigniter)?
I'm using CodeIgniter and I want to read excel file to extract data and save it to PHPmyAdmin database.
I've tried some third party libraries like
1- SimpleXLSX.class.php
2- Excel_reader
but these are not helping me.
Can anybody please give me a…
Farhan92
- 35
- 3
- 9
-1
votes
1 answer
ExcelDataReader, can't read "html-format" file
I have the following code:
MemoryStream ms = new MemoryStream();
using (var fileStream = File.OpenRead("G:\\tmp\\abc.xls"))
{
fileStream.CopyTo(ms);
}
var reader =…
Oleg Sh
- 8,496
- 17
- 89
- 159
-1
votes
1 answer
Making Hierarchical dictionary in c#
I want to build a hierarchical dictionary structure in C# from an Excel data sheet. The structure should look like this:
{
"Data": {
survey_id: {
"SurveyParameter": {},
…
must
- 3
- 2
-1
votes
2 answers
Color the rows and column in c# datagridview
I'm, trying to color the rows and columns after importing the excel sheet into datagridview.
Rows (A1, A2, A3, A4, A5, A6) should be highlighted in red. (maximum row count is 35)
Columns (Fields, Record 1, Record 2, Record 3, Record 4, Record 5,…
h3r
- 43
- 1
- 1
- 7
-2
votes
2 answers
Deprecated: Implicit conversion from float xx.xxxx to int loses precision in excel_reader2.php on line 922
OS: Windows 11
PHP Version 8.1.6
Error Mesage:
Deprecated: Implicit conversion from float 65.03846153846153 to int loses precision in C:\xampp\htdocs\sati\import\excel_reader2.php on line 922
public function…
rafaelspfonseca
- 9
- 1
-2
votes
1 answer
Deserializing csv with unknown headers to a List or Array
My question is different from other SO questions, because those deserialization samples are for a typed POCO class, in my scenario I don't have any types ahead of time. Files are being dropped in a folder from various sources.
Without, the…
Transformer
- 6,963
- 2
- 26
- 52
-2
votes
1 answer
How to write send email test case and read Excel file test case in Selenium
Here is my my code to write a sample send email test case. When running the code email is not getting triggered. Please find attached data for more details
Login User details
Invalid User Details
Booking Data
Can anyone please help to resolve the…
Aniket
- 3
- 1
- 7