Questions tagged as 'excel'

Tagged questions
2
answers

Prevent continuing program when an exception occurs

I have this method, which opens an excel file, what I try is that when the route is not correct I can not continue the program until the connection is correct. private void Conectar() { try {...
asked by 16.11.2017 / 09:10
2
answers

Error generating excel with PHPExcel

I have a generic method that is responsible for generating the excel I need, what I send to the method is the resource of a query, the method is responsible for tracing the result to generate the excel with culumnas and corresponding rows. As...
asked by 26.04.2017 / 22:07
1
answer

Error exporting data to Excel from C #

I need to export the data from a DataGriedView to an Excel sheet. I have the following code: public void exportar(DataGridView dgv) { try { SaveFileDialog fichero = new SaveFileDialog(); fichero.Filter = "Excel (...
asked by 30.01.2017 / 17:42
1
answer

Problem when exporting to excel on the server

I have the following problem I have a file php that I export to excel and download it automatically but it only works for me locally, if I upload it to the server it just opens like any other page. What can it be? <?php include_once...
asked by 21.12.2016 / 00:12
1
answer

Is there a way to prevent copying in an excel only for some columns?

Is there any way that the values of a column can not be copied in excel? I tried to make the column not selectable and protected it with a password, but you can still copy the values by selecting the columns on the sides. I think the solut...
asked by 22.11.2016 / 19:19
1
answer

macro save and close multiple open excel

If someone can tell me how to save and close multiple open excel from an excel with macro Sub SaveAll() Dim Wkb As Workbook For Each Wkb In Workbooks If Not Wkb.ReadOnly And Windows(Wkb.Name).Visible Then Wkb.Sav...
asked by 26.08.2016 / 22:34
1
answer

Use variables outside of $ sheet-each () - Laravel Excel

I have a function that imports an Excel with the Laravel-Excel library, and within that function in the $ sheet-> every (function ($ row)) {} I am adding the records in an array that I have declared inside the function but outside the $ sheet-...
asked by 09.08.2016 / 11:32
1
answer

Problem with possible macro excel vb [closed]

I am working with lots of txt files and I need a macro excel to do the following (if possible). I detail it: I have a path with different .txt with different names, this is an example    prueba1.txt       prueba2.txt       prueba3.txt  ...
asked by 08.09.2016 / 09:50
1
answer

Run a macro from a .bat

I wanted to know if it is possible to run a macro in Excel from a .bat file since I can not find a way to do it. The macro that I own works correctly but I need it to run when I run the .bat I would appreciate it if you know something,...
asked by 18.12.2018 / 17:43
1
answer

php headers excel number format

I need help printing numbers with a decimal when it comes to thousands when generating an excel with php. What is happening is I want to show only a decimal when printing the sheet, but it happens that having numbers of thousands, for example, 1...
asked by 11.12.2018 / 14:57