Questions tagged as 'excel'

Tagged questions
2
answers

PHPExcel comment in black

We have been using PHPexcel for a while to fill in some tables from the Database, it has been running for months but lately when writing a comment and modifying the Excel the comment box appears black ... There has been no change of code what...
asked by 28.10.2016 / 08:42
2
answers

Add decimals and integers

For pitching statistics in baseball you have the following: 1/3 equals 1 out, 2/3 equals 2 outs and 3/3 equals 3 outs. When you have 3 outs, it is considered a full inning. If you have 5 outs, it is considered 1 inning and 2/3 thirds of...
asked by 03.01.2019 / 20:11
1
answer

How to find data and export it to another excel sheet

I am currently working on a code which should: Read the item that the user selects from a Combobox, for example: Go to a page called "MEMORIES ACT" and search for this item, in the columns "CJ" and "CK" (it is done in these 2 c...
asked by 27.07.2018 / 18:29
1
answer

POI reading decimals

I have an excel *.xlsx with a cell of type Número , the value I have in the excel is 0,0794497914814776 but the value returned by the method celda.getNumericCellValue() is: 0,07944979148147759987 I have tried...
asked by 07.06.2018 / 12:17
1
answer

Excel formulas and rules

I have an excel where I have a column where I keep dates. How can I make the dates red by more than 30 days? I have been testing with SIFECHA and with conditional format but I do not achieve anything thank you very much The format is a short...
asked by 15.03.2018 / 12:00
1
answer

Validate if you find an attachment VBA macro gmail

I have this macro that sends several emails at the same time with different attachments to X number of previously specified emails. Always the emails must have an attachment (this is the reason for the email), I am trying that when I do not f...
asked by 26.07.2017 / 17:15
2
answers

Excel data extraction to create Python list

I have the following excel file: connection A auto connection A camioneta connection A puerta connection B camioneta connection B puerta connection B capo and I'm looking to put together a diction in python like this: Li...
asked by 31.10.2017 / 04:45
1
answer

Barcode PDF417

Good morning community, I have a small question regarding a reader that I am using in my project to recognize identity documents.    PDF417 is one of the bar codes that can be used to   print the postage accepted by the Postal Service of t...
asked by 14.08.2017 / 18:51
2
answers

PHPExcel Cells With utf8

I have the problem that I do not recognize the special characters, I tried the following but it does not work for me: Putting it in UTF8 = $titulosColumnas = array('Código', 'Inclusión de la Noticia DD/MM/AAAA', 'Fecha de la Noticia DD/MM...
asked by 23.02.2017 / 16:53
1
answer

how to fix this java.util.Date can not be cast to java.sql.Date

hi I'm uploading an excel file to jsp to save it in MySQL the excel file has two fields type date, at the time of reading the respective file I get this error java.util.Date can not be cast to java .sql.Date when executing it and I could not s...
asked by 19.01.2017 / 22:04