Questions tagged as 'excel'

Tagged questions
0
answers

Which formula do I use Excel for input and output of products?

I have a small table, where 'QTD_E' = Input and 'QTD_S' = Output, for each withdrawal of product quantity in 'QTD_E' I wanted to add how many products were taken out in 'QTD_S', what formula do I use for add a value in 'QTD_S' according to the r...
asked by 26.12.2018 / 16:54
0
answers

error saving the vector in java

This class has the function of saving the data in an excel file to an array. But you are not. Does anyone know me know why? I've already asked about the genre before but I can not edit it. public class uni { public static void main (String[]...
asked by 27.10.2018 / 22:56
0
answers

How to add Microsoft.ACE.OLEDB.12.0 to the installer of my .NET application?

Hello, I have an application that I programmed through Visual Studio 2017 that uses Microsoft.ACE.OLEDB.12.0 to query Excel files and return data. Now that I finished the project I had to publish. But when you install the application on a mac...
asked by 19.07.2018 / 19:30
0
answers

Iterate XML with VBA and pass data to cells

I am now starting to mess with VBA and I have the following problem: I was able to make a code that makes a SOAP request for a webservice and returns me an XML with the electronic point marking data of a person. So far the code works quietly....
asked by 17.07.2018 / 23:36
0
answers

0 left power query

I have some problems, what is the command to add 0 to the left in the M language? I'm using power query of excel, I have data that starts with 0 but it does not consider this value and does not bring me any results. follow the cod b...
asked by 08.06.2018 / 19:34
0
answers

Genexus X Ev. 3 - Problems reading Excel (xls)

Hello, I'm having a problem reading xls, just loading it and it appears at the bottom of the browser "Waiting for localhost (or the server)", I did the xlsx test with normal runs. I have tested in other browsers and other machines with differ...
asked by 06.06.2018 / 14:43
1
answer

Show diluted value according to the last day of the month! Excel

[Example] [1] [1]: link 1 - investment by the client; 2 - start of the contract; 3 - duration of the contract, 4 - rate of return for each customer; 5 - if the client chose to withdraw the monthly income or not; 6 - amount to be deposit...
asked by 06.06.2018 / 21:38
0
answers

How to paste an excel list into android studio and stay organized with line breaks?

List in excel CityAfonsoBezerraAlexandriaAlexandriaAlminoAfonsoAltodoRodriguesAngicosAngicosApodiApodiHowtodothisinxml As a large list, and I want for more than 2 columns, I can not put one by one, but rather paste with columns.     
asked by 12.06.2018 / 04:18
0
answers

Excel with password for editing

I am building an Excel file where I generate an array of bytes and the UI downloads the file in xlsx format, I need to open this file with password to perform edits, is there a way to do this directly in the byte array? / p>     
asked by 11.06.2018 / 16:40
1
answer

Excel and SQL - Connection between Excel file

I have the (final) code I got on the internet. In this line of code it gives error in WHERE, since it is a text: strSQL = " SELECT [VENDAS$].[Data], [VENDAS$].[Vendedor], [VENDAS$].[Total]" & _ " FROM [VENDAS$] WHERE [VENDAS$].[Vendedor] =...
asked by 07.07.2018 / 22:12