Questions tagged as 'excel'

Tagged questions
0
answers

Access and excel - load parameters

Is it possible to use an excel table as parameters for access queries? Currently I have 4 access files to perform the same process, but with different filters (I used 4 files to leave organized). The filters are basically DATE START, END DATE an...
asked by 15.09.2017 / 16:32
1
answer

VBA macro for Exel - copy data from one sheet to another with one condition

Live personal, I am completely new to VBA and programming. I need help to build a macro for Excel. Context: In the Excel workbook that is in the following link, I want to develop a VBA macro that fills in the "transatas", "finished" and "wa...
asked by 18.09.2017 / 15:06
1
answer

How to solve InvalidFormatException in xls file generated by jett?

I have a method to generate report made with jett: Map<String, Object> beans = new HashMap<String, Object>(); beans.put("fichasTecnicasMateriaPrimaResumo", fichasTecnicasMateriaPrimaResumo); try { InputStream inPath = Produt...
asked by 04.09.2017 / 17:53
1
answer

AlternativeText of sharpes to save config

wave I would like to know if there is any problem / risk of using the AlternativeText property of sharpes objects to save working parameters is there any risk that these data will be deleted / replaced suddenly by other actions inside the offi...
asked by 18.08.2017 / 12:29
0
answers

Exporting Excel using JavaScript

I would like to know how to do a function that exports a table to excel but does not show certain columns defined with a class     
asked by 10.08.2017 / 20:21
1
answer

Procv Help Copy data

I have a database in which an employee has three or more dependents, when I do a PROCV to pull a dependent one at a time, only the first and last one appears. How do I select the first in a column the second in another column and so on? EX...
asked by 03.08.2017 / 02:03
1
answer

Procv help to select data

I have a database where an employee has three or more dependents, when I make a PROCV to pull one dependent at a time, only the first and last one appears. =PROCV(B35;'SÓCIOS COOP'!C:G;5;1) How do I select the first in a column the s...
asked by 02.08.2017 / 14:28
1
answer

How to set the height of an Excel row in NPOI?

I'm trying to create a line in an excel file through the NPOI library. The problem is that I do not know how to set a size for the line. Currently, the line is capping the content of the text. How can I set the height of the line (if possib...
asked by 21.07.2017 / 16:47
1
answer

Field of view of surveillance cameras in Excel

Good afternoon Community, I have a question about Excel, in which I do not know if it is possible to make such a request. My goal is to take a plant and through a solver, place surveillance cameras at certain points of the plant to monitor th...
asked by 08.07.2017 / 14:02
0
answers

get value from the excel cell below or to the side after checking the field name

Good. I have an excel file that displays information information below. I want to extract some information and mount a single table with the following columns: theoriginalfile,itbreakstheinformationevery11lines...theideawouldbetocheckthefiel...
asked by 18.07.2017 / 21:45