Questions tagged as 'excel'

Tagged questions
1
answer

Popular Excel with Java object

Hello, I'm having a problem popping a table the way I need it, I want to do something like this. ButwithmycodeIonlygetthatpopular. HowdoIformatinthesameway?ItriedtoskipthelinestomakeitlookalikebutIcannot.publicvoidexportar()throwsIOException...
asked by 17.08.2018 / 14:54
1
answer

Error exporting Excel using Maatwebsite / Laravel-Excel

Exporting to excel works well for up to 10000 records but above that it returns me the error: "127.0.0.1 is currently unable to handle this request. HTTP ERROR 500 " Has anyone had this problem? public function getUsersRegion($region){...
asked by 22.08.2018 / 15:53
1
answer

Excel: load list of names according to the selection of another list

At school I work with a file with class worksheets (the name of the worksheet is the class number, eg 100, 200, ...). I need to make a spreadsheet in this file to generate Declarations, where I need to select the Class, and do this load the n...
asked by 27.06.2018 / 14:33
1
answer

Generating an xlsx file from a GridView that is fed by a Database

Good afternoon, I'm facing a problem when generating an Excel file, I was able to make the information appear in Excel and be shown on the screen, but I found myself with doubts when I try to generate only one file with the information, my doubts...
asked by 05.09.2018 / 20:20
1
answer

How to update the page of a site after changing the value of a field by VBA

Good evening. I would like to know how I can update the page with the date that I reported by VBA. I put the date but the page does not change. Since you do not have a button, I do not know what to do. Sub Links() Dim ie A...
asked by 11.05.2018 / 05:20
2
answers

Excel VBA - Run-time error '13': Incompatible Types

I'm getting the error '13' Incompatible types, in the line of the first If: Count = 0 For x = 1 To LastRow Step 1 If Cells(x, 8).Value = "Materiais" Or Cells(x, 8).Value = "Imobilizado" Then If Cells(x, 11).Value = "NÃO CATALOGO" T...
asked by 11.05.2018 / 19:49
1
answer

VBA code to delete line

Well, I have a code that checks the line if there is a word or phrase and deletes the line: If Mid(Cells(i, 10), 1, 50) <> "Defeito" Then Rows(i).Delete Shift:=xlUp But in the spreadsheet there are phrases like "Defect + broadband" or...
asked by 07.05.2018 / 21:12
1
answer

Rename worksheet tab

I'm having trouble renaming the name of a tab in the Excell file. I am debugging and after it gives the set with the new name..I can see the new name changed in the execution but in practice the file itself is not changed. Someone? private sta...
asked by 28.02.2018 / 02:12
2
answers

Identify the position of the first empty cell

I have a web integration that sends to my worksheet values automatically. In one of my columns I have a URL that is concatenated with the value of an ID of the next column. I need to add in this URL value, the cell position next to this examp...
asked by 24.01.2018 / 14:24
1
answer

Edit data from a DropDown List in Excel

I have a list of items in a dropdown in excel. These values must be selected by the user and from there, edit them as requested. However, I do not know how to edit these dropdown values. Can someone help me? Below is an example of two items that...
asked by 01.12.2017 / 12:01