Questions tagged as 'excel'

Tagged questions
1
answer

Error 1004 in a macro

I created the following macro: Sub Extraer1() 'Definir origen y destino que utilizaremos Dim OrigenHoja As Excel.Worksheet, _ DestinoHoja As Excel.Worksheet, _ OrigenCelda As Excel.Range, _ DestinoCelda As Excel.Range 'Definir las...
asked by 08.05.2018 / 14:27
0
answers

I want to read a data table in csv format but I get error

I want to read an Excel data table but in csv format and I get an error. x <- read.table(Tabla_de_datos_dinamica) Error in read.table(Tabla_de_datos_dinamica) : 'file' must be a character string or connection How can I make him read...
asked by 30.04.2018 / 16:14
0
answers

Error getting table with the property 'document.getElementById' in AngularJS

I am trying to get a table generated in html with the aforementioned property, for the generation of an .xls file If I pass the direct value, my .xls is perfectly accommodated as I require it: vmHome.table = "<table><tr><...
asked by 03.05.2018 / 18:32
1
answer

Correlative in discontinuous ranges excel

I have a question. Do you know how I can assign numbers or correlative in discontinuous ranges? the idea is to repeat it until space is detected, then continue but adding +1 for example: Start with a correlative 1, then when detecting t...
asked by 03.05.2018 / 22:42
0
answers

Add ContextMenu in the web manifest add-in excel VS

I need to add an item to the contextual menu in the Manifest of an excel plugin in visual studio 2017. This is the ExtensionPoint with which the project is created:                                                                              ...
asked by 23.04.2018 / 19:21
0
answers

sql query from a table in an excel file

My query is: on how to insert texts from a table in an excel file, to textboxes (vba form) using an sql query. this is the code: Private Sub cmdBuscar_Click() On Error Resume Next Const adOpenStatic = 3 Const adLockOptimistic = 3 Const...
asked by 05.04.2018 / 22:42
0
answers

add styles to excel with php

I have these two functions to generate the excel, have styles in by means of classes, how can I do so that when exporting the excel shows with the styles that I have added or in what way should I add them? / p> $("#btnExport2").click(functio...
asked by 10.04.2018 / 23:43
1
answer

Error 91-With not established

Why is this error in the code? Dim FSO, folder, subFlds, fld, ParentFolder, path Dim oFSO As Object Set oFSO = CreateObject("Scripting.FileSystemObject") ParentFolder = oFSO.GetFile(ActiveWorkbook.FullName).ParentFolder.ParentFolder.pat...
asked by 02.05.2018 / 19:32
0
answers

Generate Excel Reports in Automatic

I have a big problem, I am generating an application that generates certain reports in excel, I have some formats that I develop, the problem is that I do not know how to fill them automatically according to a selected value (Example: if I selec...
asked by 27.03.2018 / 20:30
0
answers

How to generate a report in excel with multiple fields

I want to generate a report with excel where the user may or may not enter one or more fields esta es la estrucutura de mi base CREATE TABLE 'tablacompleta' ( 'supertoken_id' bigint(20) NOT NULL, 'num_bug' bigint(15) DEFAULT NULL, 'n_caj...
asked by 24.03.2018 / 02:31