Questions tagged as 'excel'

4
answers

Get a value from a set of rows in Excel

I have a table in Excel that represents the purchase orders. Ex: pedido | linea ped. | estado línea ----------------------------------- 1 | 1 | Cumplido 1 | 2 | En progreso 2 | 1 | Cumplido...
asked by 21.02.2017 / 13:21
1
answer

Add an AND in the SI function in Excel

I need to create a function in which I say: SI porcentaje_cruce >= 80 Y Claificación_final >= 50% entonces 2000 si no es 0.     
asked by 04.10.2018 / 16:39
1
answer

Why is the download of an excel file forced?

I am trying to show an excel file, but this one instead of showing what it does is download it at once. Thus I try to show the file public function ari(){ $file = storage_path() . '\app\excel\formulario ORIGINAL ARI.xlsx'; $heade...
asked by 24.09.2018 / 18:41
1
answer

No values specified for some parameters (EXCEL / VB.NET / OLEDB)

Very good community! The following problem I had experienced before when I made modifications (UPDATES) to the excel sheet, but I always found some solution ... but ... not now ... and the funniest thing that I am following to the letter The ste...
asked by 18.09.2016 / 19:59
1
answer

How to export to Excel with php and Sql Server 2008

I want to generate an excel report of my markup query. but I could not. I get the following error in the excel. <b>Fatal error</b>: Class 'Conexion' not found in <b>C:\xampp\htdocs\intragarzon2.0\formatosTH\marcaje\core\b...
asked by 17.05.2018 / 14:10
1
answer

Copy to a specific character. Excel and visual basic

I am working on a program using VB and EXCEL. Currently I have to copy certain information from one cell to another to generate a report. Everything is working well for now. But I have the following doubt. One of the lines, contains the histo...
asked by 04.09.2017 / 16:51
1
answer

how to save an excel range to acces with this code

I have this excel vba code Dim cs As String Dim sPath As String Dim sql As String Dim sql2 As String Dim cn As ADODB.Connection sPath = ThisWorkbook.Path & "\datos.accdb" cs = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & sPath &...
asked by 30.05.2017 / 17:03
5
answers

Problem with date format when transcribing it to a box with VBA - Excel

I am working on a macro in which through a form and a text box called fechasolicitudreq . I'm saving the dates in the corresponding cells. I have tried the following formats: Cells(i,j).Value = Me.fechasolicitudreq.Value...
asked by 13.01.2017 / 16:09
2
answers

Can I do a counter in macros that registers me accounts times a macro is executed?

I would like to know if you can do a counter or a boolean that changes every time a macro is executed, since I need to make a conditional that validates if a macro was executed to perform a certain action. note: the counter will be used in a...
asked by 14.09.2016 / 21:27
2
answers

Download in Null

On my%% co_button I have a "Descargar excel" that leads to the following function in onclick : function downloadExcel(status) { $.ajax({ url: "http://localhost/WareHouse/reporte.php?status="+status, type: "GET", succ...
asked by 14.12.2018 / 22:44