Stack Overflow
Stack Overflow

Questions tagged [excel-reader]

37 questions
0
votes
1 answer

How to fetch single row from excel sheet and pass into testng data provider using java

I have a scenario to fetch entire 3rd row data from excel sheet and pass to data provider. I can fetch all the row available in excel sheet (Please find the code below). But, I want to fetch nth row of data and pass to data provider annotation.…
Indu Devendran
  • 1
0
votes
0 answers

pyinstaller --add-data feature reads files once when bundled?

How to read with exe file files in exe file destination everytime newly when exe is executed? If I add file with pyinstaller (--add-data) -> it's called bundled file. Then When I execute the exe file,...and I have already modified let's say edited…
xlmaster
  • 659
  • 7
  • 23
0
votes
0 answers

Open excel file before read it using javascript

I just want to open excel file before reading the uploaded excel file, i am using xlsx.read javascript API to read uploaded excel file, before that i need to open the file because the file is being password protected, i have shared the both concepts…
user3321757
  • 37
  • 1
  • 8
0
votes
0 answers

XLSX.read Javascript API unprotect password in JavaScript

I am using XlSX.Read Javascript API to upload excel file, while trying to upload the excel file i need to un protect or remove the password, or any other way to un protect or input the password in Javascript, i have attached the code below for your…
user3321757
  • 37
  • 1
  • 8
0
votes
0 answers

Unable to copy a URL from an excel cell and send it to a webpage

Unable to copy a long URL from Excel to a webpage field though if i directly hard code and send it works perfectly i used this excel command to read and it didnt work while the rest of the fields work perfectly Local $Read4 =…
Pradeep Chellakani
  • 1
0
votes
0 answers

Phpspreadsheet : Uncaught InvalidArgumentException File "filename.xlsx" does not exist

I am working on a project using PHPspreadsheet, it is a filter for an excel file. I am facing a problem which is File does not exist, but I am sure that I am putting it correctly. it was working but after some days I reviewed my code, and I am…
Zizmotrex
  • 61
  • 1
  • 7
0
votes
1 answer

Program to convert XLS files to CSV not creating the file when run

I am building an application in Visual Studio 2019 Community edition to convert an Excel XLS file to a CSV. I had found some example code that was using the ExcelReader library and modified it so it would pull the XLS file and make a test.csv file.…
htmlbran86
  • 203
  • 1
  • 3
  • 13
0
votes
2 answers

Plus sign lost when reading excel sheet with pandas

I have a list of phone numbers in an excel sheet, along with other information related to the phone numbers. The phone numbers can be from different countries, so they start with a + sign, followed by a country code (for example +1055592947). The…
Simen Russnes
  • 2,002
  • 2
  • 26
  • 56
0
votes
0 answers

I want to write set of random numbers in an Excel sheet by iterating rows .I am able write random numbers and I am unable to store them in excel

I want to generate random numbers and parallel i want to write them in excel sheet in 1st column upto 15 rows. I tried with below script, but, it's not working. I tried with below script, every time I want to store up to 15 numbers and those…
Mani
  • 75
  • 2
  • 10
0
votes
1 answer

The method getCellTypeEnum() is undefined for the type XSSFCell

Can someone help me to update the below code since getCellTypeEnum() shows error: The method getCellTypeEnum() is undefined for the type XSSFCell Any help will be appreciated. private void prepareInnerList(List innerList, XSSFRow xssfRow,…
dharmender patel
  • 1
  • 1
  • 1
0
votes
1 answer

Reading each row of excel sheet using Java

I have n rows and Columns of Excel sheet . example Name OrderId Count Date ANC 1234 5 23/3/18 ABCD 2345 6 23/3/18 XYGS 3567 7 23/3/18 So in the above data , i want to read the Orderid and Count and give them as input to the next call. I have…
jlearner
  • 1
  • 1
0
votes
1 answer

Excel file upload failed due 'db' does not exist in the current context

I am trying upload excel file and then display and save it on database.I am using Entity Framework code first.If I display the file than it is working fine but if I try to save it to my current datacontext I am getting this error "'db' does not…
delta12
  • 97
  • 1
  • 8
0
votes
0 answers

Spreadsheet_Excel_Reader one column show question mark reading in PHP

Please check this image ###### value showing que mark. If I upload this column value on database this value save with ??????? like. I am using Spreadsheet_Excel_Reader in php $data = new…
Shoaib Quraishi
  • 232
  • 2
  • 17
0
votes
1 answer

Exception in reading Xlxs filenull

This is my script code. i am trying to extract data from excel sheet but there is an error saying exception in reading xlxs filenull public class TC003_VerifyLoginWithDifferentRecords extends testbase { public static final Logger log = …
user4611613
0
votes
1 answer

c# IExcelDataReadReader and a specific Sheet

I have a program that needs to read an excel file and write it to sql server.I am using IExcelDataReader and my code works as long as I have one worksheet. If I have another that for an example has some information that I don't need to insert,I…
Alexander
  • 405
  • 7
  • 17
1
2
3