All Questions
64 questions
1
vote
1
answer
63
views
Read Date from excel and insert into PostgreSQL
I have problem while reading date from Excel file using Apache Poi.
I use the following:
FileInputStream inputStream = new FileInputStream(excelFilePath);
Workbook workbook = new XSSFWorkbook(...
- 127
0
votes
1
answer
57
views
How to insert a date (12-dec-2020) from excel to mysql
i got the data from in excel file and pet it into an array string, the date is in the format (12/12/2020) whine i print it withe the method toString() i get (12-dec-2020), and when i tried ...
- 17
0
votes
0
answers
872
views
Date format Issue while reading with Aspose
I want to read dates from .xlsx file , I am using Aspose to read the date value from the column,
But the output date value i got was in a different date format, Following are the dates needed
in ...
-1
votes
1
answer
191
views
How can I parse this numbers to timestamp? [duplicate]
I have a excel file I read in java. There is a column contains dates. if I format cells a can see real dates. I have no problem in excel but i read this cells as string in java times looks like this;
...
- 122
1
vote
0
answers
41
views
Java - Excel Import Dates and Numbers
I am currently facing a small problem.
I am trying to import numbers from an excel-file. While testing the import, I figured out that dates are NUMERIC values. And so, users can accidentally type in a ...
- 11
1
vote
1
answer
1k
views
APACHE POI setting cell style clears existing date format
I am new to Java programming and this is my first post so hopefully it's a valid question. I have searched the archives but can't find a suitable answer.
My class is reading and validating a ...
- 11
0
votes
1
answer
430
views
Apache POI - Parsing Dates with HSSFListener
First off, I'm working on using Apache POI's Event API using HSSFListener and XSSFSheetXMLHandler.SheetContentsHandler to read large files. So I'm not using a workbook where I can use some of the ...
- 885
-2
votes
2
answers
276
views
Java date conversion formats [closed]
from date format change to this format - 01-Jan-2019 in excel using java.
I want to read the date format in excel. if suppose having any date format want to change DD/MMM/YYYY format. ie., 01-Jan-2019....
- 1
0
votes
1
answer
2k
views
How to read "Date" value from "Excel" and send that value into "Date picker" using "Selenium WebDriver"
I used an excel sheet with "Date" as the cell type, in format dd-mm-yyyy
In selenium code i used below code
String value = String.valueOf(sheet.getRow(1).getCell(1).getDateCellValue())
driver....
-4
votes
1
answer
175
views
Convert "using excel method" numeric value in date - java
I have an integer that when I put on Google Sheets, it represents the date 14/10/1911 (integer value is 4305).
I need to do this same conversion in my code using Java. So I'll have an array of ...
- 149
-3
votes
2
answers
338
views
Excel Date format to number in JAVA [duplicate]
I have a question:
I have the current date in a cell with date format like:
5/12/2018
When I formatting this cell to a number (right click -> cell format -> number), I got this:
43439,67
How can I ...
- 129
0
votes
0
answers
93
views
Date type in SQLite
I have an excel file in which I have many columns of dates which format is yyyy-mm-dd when I upload excel file in SQLite using java program. All data upload in their respective columns but date format ...
- 105
2
votes
1
answer
138
views
JXL(Java) change to 1904 date system
I need to change date system to 1904 calendar using JXL (rather than 1900 calendar).
Everytime I write something in Excel using JXL API, date system is set to default and I need to change date system....
- 1,009
0
votes
1
answer
194
views
Unable to read excel cell value having date field using Java
I am exporting my data to excel sheet with date field as one of the columns.
e.g. I am exporting data as 28/10/2018 12:32.
I am editing the date.
After importing the date, it is giving me the date in ...
0
votes
0
answers
54
views
Java:Not able to read a Date from excel cell
I have an excel sheet, which contains a date in cell D3, This "D3" as value is given in some other cell. I tried to access this date by cell reference but I'm getting a strange number instead.
Below ...
- 1