Questions tagged as 'excel'

Tagged questions
4
answers

How to click on a web button from excel that has neither id nor name?

I need in Excel (vba) to make a macro or robot to enter some data in a web page taking as values a list of data (cedula and date) that I have in an Excel sheet, those parameters I can already pass to the form with this element "IE.Document.getEl...
asked by 14.06.2017 / 23:23
1
answer

Excel cell with several lines from .Net

I am dumping information from a SQL Server table into an Excel file. One of the fields that I overturn is a field of observations that may contain line changes. If I dump the information without more the result is the following: oRng = o...
asked by 08.03.2017 / 12:31
0
answers

Explosion of materials from a recipe accommodated by ingredient type [closed]

There is some way to convert the following table: accommodated through a dynamic table or a formula to: To be able to add a new cake each time and automatically integrate each Row     
asked by 11.11.2016 / 00:42
2
answers

PHPExcel error with Codeigniter

I am using PHPExcel with Codeigniter in a fairly simple way: $this->load->library('PHPExcel/Classes/PHPExcel'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setTitle("Gastos")->setDescriptio...
asked by 04.11.2016 / 21:39
2
answers

excel protect cells

I'm trying to protect with password a column of IDs in excel, is it possible to do that without block the rest of the sheet? Thank you.     
asked by 23.05.2018 / 13:55
2
answers

Compare multiple Excel columns

From the following previous image I want to create a macro that does the following: What I want is to make a cycle that runs through the rows of my data: compare row1 of column A with row1 of column G and compare row1 of column B with r...
asked by 21.02.2018 / 23:23
1
answer

Formula to get the Excel PAGOPRIN function

I was searching the Internet and I could not find the formula used to obtain the Excel function payment, you could tell me the formula to get the result or where I can find it     
asked by 15.11.2018 / 19:20
1
answer

How to keep the file name when downloading it?

I have a small problem with the name of the files when they are downloaded. So I release them public function expensesAndTravel(){ $file = storage_path() . '\app\excel\REPORTE DE GASTOS Y VIATICOS.xlsx'; $headers = ['Content-Type' =>...
asked by 25.09.2018 / 15:11
1
answer

Do filtering with a finite range with VBA

I want to do a self-filtering through VBA of a table with multiple columns. My intention is that it does not filter to infinity, if I do not always have control knowing which is the last record of my table. My code is the following: last...
asked by 08.08.2018 / 11:55
1
answer

Export data from excel to sql

How can it be done to export an excel table to a SQL Server table and also, whenever someone adds, edits or deletes a value from the excel table, that same value is removed from the sql table? I have already been able to export the values of...
asked by 15.02.2018 / 17:54