Questions tagged as 'excel'

Tagged questions
0
answers

How to loop in VBA from autofilters using value "differing from"

Good afternoon, doing an automation in VBA in which I need to loop through filters on different lines (sequential values from 1 to 95) but my selection will be with the filter criteria "other than". Copy the excel tab to a new worksheet, sele...
asked by 08.05.2018 / 22:45
0
answers

Database photo

I have a spreadsheet that I need to put photos by pulling from a database. The trigger would be the product code. When you enter the product code, the photo of the product would go up to the spreadsheet automatically from the database to a sp...
asked by 20.04.2018 / 15:14
0
answers

Change field format in excel to import into sql server wizard

I need to do a data import from an excel to sql server. My big problem is that the data coming from the source of an excel column is being interpreted by this wizard as varchar, even though I make all the changes that I can imagine. Basica...
asked by 24.04.2018 / 14:17
1
answer

Transpose data automatically

I have the following problem, I need to create a "robot" that read the data of a certain cell in Excel and enter that data in another software (company's own software in which I work), but it has to "type" exactly the data that was read from tha...
asked by 16.04.2018 / 05:11
1
answer

How can I tabulate a bulk file?

Hello, I have a file of 64500 rows and 11 columns to tabulate. The original file came from the counter system, which is a system for printing paper. I've been able to get the headers out, but I'm having trouble with the tab. Does anyone know of...
asked by 17.04.2018 / 23:23
0
answers

EXCEL: Form with filling in specific places

InthisimageIhave7"blocks" to be filled via form, they are side by side. As I do in vba a function that fills in these blank fields of TM1 and TM2 automatically, I want to include this function in a form to fill with the forward and back button,...
asked by 14.04.2018 / 05:30
1
answer

Formatting charts in Excel

How do I get the information from a server using mysql when this information appears in the spreadsheet with already formatted chart in excel?     
asked by 10.04.2018 / 15:03
1
answer

How to hide a table in excel without resizing the chart

I would like to hide a table but it feeds a chart, I would like to do this without resizing the chart. This graphic uses selection buttons that have been formatted with macros.     
asked by 10.04.2018 / 13:40
0
answers

Import .xlsm with laravel excel maatwebsite

Good afternoon. I am having trouble reading an .xlsm file. I use the maatWebsite library to import files. Error Information. PHPExcel_Calculation_Exception in Cell.php line 293: P. ACORDOS!B2 -> Invalid cell coordinate B Import Code...
asked by 09.04.2018 / 17:20
0
answers

Insert Excel data into a site

I have a spreadsheet in excel which is a large list of several rows and 5 columns. I need to insert the data of this worksheet into a website (html form), each cell in its respective field, save and select a specific button of the page (eg, simu...
asked by 31.03.2018 / 22:24