Questions tagged as 'excel'

Tagged questions
1
answer

VBA Excel Worksheet_Change Problem

I have a problem when coding with Private Sub Worksheet_Change(ByVal Target As Range) Because there are so many cells that make changes and that in turn are triggers of each other, that the time has come when excel tells me "the pro...
asked by 23.02.2017 / 03:37
1
answer

Hide my OLEDB connectionstring in Excel

I need to hide the password or the entire connection string to outsiders who use a certain template in Excel 2010. To create the connection, I follow the following steps in Excel: "Data" tab Option - "From other sources" Option - "Fro...
asked by 28.02.2017 / 22:06
1
answer

How to make a macro so that an Excel Button generates an action?

How to give a function to execute a button in excel, the excel button is a drop-down list button, so I want to execute an action, the action I want to give me is that I see a box to complete in which I already have the macro for it, what I do no...
asked by 22.02.2017 / 16:44
2
answers

Export Excel file with PHP - Format error when opening file

When exporting an excel file with php, the file can not be opened because it sends me a format error. It should be noted that I am trying to open it with Excel 2013 This is the error:    EXCEL CAN NOT OPEN THIS FILE.       "The for...
asked by 05.12.2016 / 14:12
1
answer

Read excel with Apache POI in java by column name

Good afternoon experts, I have a problem with a project that consists of reading an excel file and validating the data by columns, I have managed to read the file without problems and also validations (through regular expressions) through the li...
asked by 10.03.2016 / 00:39
1
answer

Format Excel Date in Java

I have a question, I hope someone can help me: In Excel, inside a cell I have a date, for example, today: 2/12/2018 To this cell I give a right click - > Format of cells and format as a number, with which I have the following result:...
asked by 05.12.2018 / 22:23
1
answer

what should I do to show me the correct number and not formulated

I have a cell formulated with an SI and the result must be a number, I went to cell format and select number format. Now from word I am trying to print on a pre printed form, so scan the form and import it in word and there I assign the excel...
asked by 28.06.2016 / 19:31
0
answers

Excel VBA Run-time error '70': Permission denied (If I run) [closed]

When I run the next Code it triggers an alert that says Error '70', but when I run it Step by Step It works Perfectly !!!! Sub Arribos () Dim IE As Object Dim objElement As Object Dim objCollection As Object Dim i As Integer Dim j As Double...
asked by 14.06.2016 / 20:29
1
answer

How to handle ERROR .Find (). Column in VBA?

I have the following line of code: columna_inicio = Range("4:4").Find(fecha).Column The problem is that if date does not exist, the program releases an error. How can I handle this? I tried using the Try Catch but I can not get it to...
asked by 27.07.2018 / 11:00
4
answers

Graph data from an excel spreadsheet with Python

I wanted to make a graph of the data I have in an excel using python. In the first column of the excel I have time values (x axis), and in the other columns values of inensity (y axis) for each time. From what I've read, I can use openpyxel t...
asked by 06.10.2016 / 18:26