Questions tagged as 'excel'

Tagged questions
0
answers

How to place several dates with Date and Time Picker in a ListBox?

I would like to know how to insert 2 or more dates with the Date and Time control, selecting the "Select date" button and selecting the dates from the control. Or, if there is a better solution I am open to your answers. Thanks     
asked by 10.09.2018 / 17:21
1
answer

Create temporary file and open it with pandas

I am trying to create a temporary excel and open it, to later delete it. With this, what I intend to do is to be able to consult an excel without having to save anything in memory. My code is: def abrir(self): nombreFichero = "Tempora...
asked by 07.09.2018 / 10:49
0
answers

Know the name of the first table of an excel sheet in VB.NET by OleDB

good afternoon. I'm connecting to an xlsx excel file using OleDB, I wanted to know, in what way can I know the name of the table in the file. That is to say, every day they send me an excel file where the table changes. Then I to do the queri...
asked by 05.09.2018 / 22:10
1
answer

Extract content from DataGridView from SAP to Excel with Macro

I'm having trouble passing the contents of a DataGridView SAP to Excel with a macro. I get the error:    "The object does not support this property" Here where you mark me in the VBA This is the code section: Su...
asked by 09.09.2018 / 06:15
1
answer

Count cells in a filtered range

I am working on some Excel reports in which we need the amount of tickets that are not being attended (empty cells), according to other criteria. Currently this is what I have in my code gsh.Shapes("UnpickedCE").TextFrame.Characters.Text =...
asked by 06.09.2018 / 18:08
0
answers

You can not create or use the data range reference because it is too complex

I tell you that you gave me this error in excel when I filtered information and I wanted to copy them, I found that Excel only allows you to select non-contiguous ranges of 8,192 areas. Non-contiguous Ranges las soluciones para este probl...
asked by 07.09.2018 / 01:39
0
answers

Return the excel writer

I have a window to open or save an excel and what I pretend is that when I save the excel this modal I return the content of the excel, that is, the writer to be able to add modifications to that excel. My code is as follows: import pandas as...
asked by 05.09.2018 / 09:18
0
answers

How to save file in UTF-8 format in VBA

I have a macro that works well, it saves a file in .csv and puts double quotes, which I need. The problem that inside this file I have special characters (in Korean, Chinese, etc) and when I save it, it changes me. I was reading and I thin...
asked by 31.08.2018 / 19:08
1
answer

C # problems with. Replace () in an excel sheet

I am trying to remove the commas from a cell inside an excel file, but I have the situation that after applying my code in the first row everything is fine I have no problem, but from the second round my code will be stop completely in the same...
asked by 29.08.2018 / 18:32
0
answers

I can not export html table with the SheetJs library solution?

Every time I click the button the saveAs function tells me in console that it is not defined. $(".btn-buscar").click(function (e) { e.preventDefault(); var workbook = XLSX.utils.book_new(); var worksheet = XLSX.utils.table_to_shee...
asked by 27.08.2018 / 20:38