Questions tagged as 'excel'

Tagged questions
1
answer

Break line automatically in export to Excel by Delphi

I'm doing an export to Excel using Delphi. At some point, a text ends up being larger than the size of the cell, "popping" its contents out of the cell when opening the generated .XLSX file. I would like to know the command used to apply the...
asked by 17.09.2018 / 19:21
2
answers

Exporting an .xlsx with Java

I'm trying to export a spreadsheet with Java, specifically a .xlsx file, but I'm not getting it. I'm doing it this way and it's working, but it only works by putting the extension .xls : HSSFWorkbook workbook = new HSSFWorkbook...
asked by 10.10.2018 / 17:36
1
answer

Increment in String in VBA excel

A Strign in VBA excel has the following value: "T110A17014". I need to increment this string with each iteration. To increment only the last position the code below works! Now if we have this value: "T110A17099" and use the code below it will lo...
asked by 28.08.2018 / 07:47
2
answers

VBA - How to search for words from one list in another and point to "Found"

Good morning. I packed it. In plan1 column A I have a list of 20 different words. In plan2 Column C I have complex texts in every cell. I need to go through plan2 Column C looking for words contained in plan1 Column A if the wor...
asked by 19.07.2018 / 15:54
1
answer

Update PivotTable with connection to a Stored Procedure using VBA Macro

I aim to bring the data from a Stored Procedure to a worksheet in Excel. This Stored Procedure is using two parameters for the query. Excel 2013 SQL Server What I have I mounted a macro that queries the database, updates a table with...
asked by 09.07.2018 / 16:49
2
answers

Pass database txt to mysql

Hello, I have a txt file where I wanted to get your content to put in a database, but I'm having trouble following an example of how the file is: [03471] Nome=fulano Idade=20 Sexo=Masculino [05232] Nome=fulana Idade=17 Sexo=feminino I wante...
asked by 05.08.2018 / 12:00
1
answer

Function of converting decimal numbers to extensions using VBA in Excel

I have a function, = SpellNumber (), which when I put a number there, it drops the number in full. Agr, she looses, on the part of the cents, and X Cents. I wish she would let go with X / 100. Does anyone know how I change the code for her to do...
asked by 16.07.2018 / 18:52
1
answer

Change cell values excel

I need MACRO to change the value of a cell in excel. An account type field has the following value: $ 15.326685459. I need to change the cell automatically so that it stays: R $ 15.32 billion. Does anyone know how I can do this?     
asked by 14.06.2018 / 15:02
1
answer

Copy data from one column (B) to another worksheet, if column (F) condition is met. excel

I have tried and continue to try various codes to automate the copying of data (column B, worksheet proposals) to another worksheet, also in column B, if column F of the "proposals" spreadsheet contains the terms "Accepts" or "Sent". Both wor...
asked by 16.05.2018 / 13:49
2
answers

Copy data from one worksheet to another

I have a problem in a macro, I'm trying to copy data from one worksheet and paste it into another one, but it's giving an error when inserting a new line (in yellow). Sheets: Code:SubcopiarDadosEntrePlanilhas()Application.ScreenUpdating=Fal...
asked by 23.04.2018 / 14:10