Questions tagged as 'excel'

Tagged questions
0
answers

CMD - Batch with FTP - Error raising excels (.xlsx) [closed]

The .bat uploads the file but it seems to corrupt it, it marks me that it uploads correctly and I check in the FTP and in fact I see that it has been uploaded but when opening it (downloading it to the PC or opening it with a php library) it say...
asked by 25.04.2018 / 17:18
1
answer

How can I send Excel from sql server?

Good Night. I'm exporting an excel file to my email from SQL SERVER 2012 Why, if it generates me and my email arrives to me the excel the bad thing is that it comes out in a single cell as the image that I attached Would there be a way to for...
asked by 18.01.2018 / 01:12
1
answer

Repeat the field value of an SQL query

I'm doing a query in SQL and with the following need in the table I have the document in two moments or status (1) when it originates and (2) when it is "linked to another process" the point is that when I generate the query only the records of...
asked by 09.03.2018 / 00:27
1
answer

How to execute a loading bar when a macro is running? [closed]

I have a book
asked by 14.06.2016 / 06:05
2
answers

Read Excel data with Qt Creator

I would like to know how I could read the data of an excel from a Qt application. I've tried it with the following code but it reads data without sense. #include <QFile> #include <QStreamText> int main(){ QFile archivo("datos....
asked by 06.11.2017 / 12:17
2
answers

Error: VBA types do not match

I'm doing a macro that compares two columns at the same time to perform an operation, column A is of type Integer and column C is of type Date, the problem is that when closing the cycle it throws me the error of <Se ha producido el error...
asked by 08.11.2017 / 05:47
1
answer

C # format of a cell in excel

I need to open an excel file xlsx to remove the commas from a pair of tables so that I can convert the file to .csv . I want to know if I can do this with a NumberFormat or something similar? I'm starting from row 15, that's where the infor...
asked by 28.08.2018 / 00:31
1
answer

VBA Select html element by classe

I need to access the value of an input and click on another with an Excel macro and I need to select the inputs through its class, since they do not have an id. I've seen googling that the .getElementByClassName () method exists, but there's no...
asked by 20.04.2018 / 22:47
1
answer

Date operations in Excel VBA

I was asked to perform a macro in VBA and I am having a problem that I have to perform an operation with dates, I recover the date in the format "hh, mm" [15:59 ] and trying to make a subtraction between two dates generates an error 13, that t...
asked by 14.09.2017 / 16:28
2
answers

insert an apostrophe before a query to excel

I have this result of a query $consulta .= '<td>' . $v . '</td>'; where the variable ' . $v . ' is a number that contains leading zeros, so that excel recognizes that number in text format, I must add an apostrophe 'befor...
asked by 31.08.2017 / 15:46