Questions tagged as 'excel'

1
answer

How to handle the unusual closure of a ComboBox list in VBA?

I'm creating an important effect for a particular ComboBox presentation. The text of this ComboBox is originally centralized , and when you open your list, I make the text left aligned for items in your list to appear < strong> left-alig...
asked by 20.05.2016 / 06:46
1
answer

How to "Copy and Paste" a form in VBA?

I have a form ready that I want to take advantage of everything I did for him but in another form, it would be the case to do something similar to "Copy and Paste", how can I do it?     
asked by 15.05.2016 / 23:16
1
answer

Create add-on that associates number with an image

I need to create an add-in that associates a number with an image. Example: =getImageQualidade(1) 'e nessa célula ficava a imagem. I already know how to create / implement a basic add-in in Excel link Now my problem is in the code....
asked by 09.02.2016 / 14:50
1
answer

Copy and paste cell when changed

I'm starting to use VBA with the office package, as I still know little I'm having trouble getting this functionality. I was trying to do something simple and needed help to understand how it works: I need if one cell changes, its contents...
asked by 06.11.2017 / 14:57
1
answer

Read merged rows and columns in excel, using python

I'm having trouble reading information from a spreadsheet that has merged rows and columns. I tried using merged_cell to get the value, but I do not understand how it works. Can anyone help me? Using the script below, I can get the values, e...
asked by 21.08.2014 / 21:15
1
answer

How to merge multiple Excel spreadsheets into one?

I have a set of worksheets (for example, suppose they are called file01.xls, file02.xls, file03.xls, etc.), all with the same columns in the Sheet1 tab and with the other empty tabs. How do I merge these sheets into one without having to open, c...
asked by 21.11.2018 / 21:47
1
answer

Problem deleting data from a worksheet

I have the following code snippet that connects to excel, where it will exclude data from a tab in a spreadsheet. private void AtualizarPerformanceEntrega() { try { string sFileXLSX = Server.MapPath("ExportPer...
asked by 04.10.2017 / 15:11
1
answer

Range.Paste Runtime error when pasting web data

Hello. I am extracting some data from an html table from an ERP which due to limitations lead me to this. Anyway, the problem consists of, when copying the table and try to paste it with range.paste or special past error. The complete code:...
asked by 04.02.2016 / 20:48
1
answer

Excel tabs that have been saved in html: how to take it up

I made a spreadsheet in excel with several tabs and then saved in html because I want to use it on my site. The tabs on the worksheet are at the bottom, the site user would have to scroll down to change the tab you want, I'd like the tabs to...
asked by 14.09.2018 / 01:25
1
answer

Return Dowload Excel via MVC Controller

I have a method that generates an excel file and writes it to a directory, but then I get the directory path and need to download the excel file, but nothing happens, no error. Can someone help in what I'm failing? [HttpGet] public FileRes...
asked by 29.05.2017 / 20:13