Questions tagged as 'excel'

Tagged questions
1
answer

The filter is not being applied VBA

I want the 5 filters to be applied on the sheet, but the last one (date filter) is blank even though the date is taking it correctly :( Any ideas? Sub Macro2() Dim hoy As Date Dim fechaVisita As Date hoy = Date fechaVisita =...
asked by 28.09.2018 / 00:00
0
answers

Import data from excel file to SQLite

I need to import the data from a .csv file selected by the user to my database This is my code: private static final int COD_SELECCIONA_TXTCLI = 12; private static final int COD_SELECCIONA_XLSCLI = 13; private String myPath; public void el...
asked by 26.09.2018 / 19:11
0
answers

Script Capture SAP floating window text

I would like to ask for some help with capturing text from an SAP floating window. I'm working with SAP script and macro excel. at the end of the script, I tried to save it in a text variable, but it brings me the text of the header of the...
asked by 25.09.2018 / 23:06
1
answer

Read format or style of cells in Excel with Python

as with Python it is possible to detect, validate, read, compare or know the format or style of one or several cells in Excel, to be able to filter and / or discard by color.     
asked by 22.09.2018 / 06:14
0
answers

Printing is repeated in SAP Script

I am working with a macro, which prints the dispatch guides. He does it correctly, but when I'm going to print one followed by another, the first one is repeated. See in the image that I was repeated the branches Llanquihue and Osorno. I a...
asked by 24.09.2018 / 23:01
0
answers

string to date pandas ex

I have a problem with data conversion. With the strtime function I convert the string into the date format I want and write it in an EXCEL cell. When I open EXCEL, it detects the format (through the EXCEL cell format menu) but not quite ... beca...
asked by 23.09.2018 / 08:40
0
answers

Progres Bar to know the progress of insertions through excel.csv

This is my import_excel form which imports the data from an excel.csv file to my BD, what I need you to do is to show me through the Progress Bar the insertion progress of all my records in my BD but I do not know how to do it, I already try wit...
asked by 21.09.2018 / 12:24
0
answers

problem when downloading a report in excel

When I download a php form there certain records that come out "run" instead of appearing the name in the field name appears in the field field and that causes all the records to be run. I leave the continuation code: <?php /*******EDIT LIN...
asked by 03.10.2018 / 17:22
0
answers

Generating a spreadsheet with PHP does not appear the same in Open Calc as in Excel

I have a problem with generating a spreadsheet with PHP, the problem in particular when generating it if I open it with Open Cal it opens in the correct way, but with excel it is different since it does not include the accents and it is not for...
asked by 14.09.2018 / 11:29
1
answer

How can I export a file in Excel that shows the leading zeros using the PHPexcel library?

Good morning, I have some data in MySql which I export to Excel using the PHPExcel library, but some of the codes contain "zero" on the left, example: 010, but at the time of generating the Excel the data remains as "10" and I need it to be as i...
asked by 11.09.2018 / 18:09