Questions tagged as 'excel'

Tagged questions
0
answers

how do I download only my gridview in c #?

I have a problem when downloading my GridView to excel since my method causes the whole page to be downloaded as for example the DropDownList that it contains, before I had the code in a Template but I passed it to a Form and it continues to mar...
asked by 28.08.2018 / 20:44
0
answers

Open a temporary excel in python

I have been looking for how to open an excel but I have only found how to open an excel already created: os.system('start excel.exe "%s\file.xls"' % (sys.path[0], )) What I'm doing is a "Do you want to open or save the excel?" window, but f...
asked by 23.08.2018 / 14:41
1
answer

Document_Open () fails when I open the document by Macro vba in Excel

I have an excel with the following vba code: Dim objWord Dim objDoc Set objWord = CreateObject("Word.Application") Set objDoc = objWord.Documents.Open("Ruta") 'Ruta verificada And I have a word document with this vba code: Private Sub Doc...
asked by 22.08.2018 / 15:42
1
answer

How to convert a date and time format to excel?

download a database of an app, and the date column brings it to me in this format 2018-08-22T00: 38: 26.354Z I require how I can convert it to a readable format in excel . Postscript, I do not know any programming language.     
asked by 23.08.2018 / 23:49
0
answers

Macro Slicer runtime error '1004' application-defined or object-defined error vba excel

I need to create a slicer that affects all the pivot tables that belong to certain types of work orders. For that first I create the slicer from a pivot table, and then I try to add the other pivots by means of a macro Sub Button13_Click()...
asked by 24.08.2018 / 23:55
1
answer

generate reports (excel or pdf) django

hello good I want to generate some type of report from the results that my searches generate, all this of a web project in django, here my views: What would be the easiest way to generate these reports ?, Thanks in advance.   ...
asked by 14.08.2018 / 18:40
0
answers

How to load information in an open Excel from a PHP

I have this code and what it does is that it keeps information inside an excel, in this case "Hello World!" , but what happens is that the excel has to be closed so that such execution can be made and when I try to do it with the open excl it se...
asked by 13.08.2018 / 16:49
1
answer

Format of Date in column to export in Excel C #

I try to export a datatable to Excel but in some date columns I export them in number, I already tried sending from the database the information I need but it does not work.     
asked by 13.08.2018 / 18:53
0
answers

SELECT query * FROM Does not bring all the data

I'm doing a query from one excel file to another. Through a recordset with the method SELECT I bring the columns that I want to my base, the problem is that I have a column Date de Facture with data type DATE (04/01/2018)...
asked by 09.08.2018 / 12:43
1
answer

Image (Image1) userform to excel sheet

Good morning. Greetings to all, I'm doing a small macro in excel with vb-userform where I have several text fields, this data is passed to an excel sheet with a button. This image I want to add it to my sheet. I am using this code, t...
asked by 15.08.2018 / 18:26