Questions tagged as 'excel'

Tagged questions
1
answer

Color Palette (VBA / Excel), right-click event for Frame objects

I could not find reference to the event that is triggered by the right mouse button in a Frame object. With the left mouse button event I select the desired color, this is working, but with the right button I would define the custom colors dynam...
asked by 08.12.2015 / 19:53
1
answer

Doubt in table generation in excel file

I have a Javascript function that generates the table of a page in an Excel worksheet. Here is the code below: function montaExcel(){ var tab_text = "<table><tr><td><img src='http://xxx.xxx.xxx.xxx/images/layout/logo.j...
asked by 29.09.2015 / 18:23
0
answers

Reading cells with HLOOKUP formulas

I'm having a hard time evaluating a formula with the Apache Poi API in a cell that contains the formula HLOOKUP(B9,$AK$8:$AS$68,2,FALSE) . The same thing happens to be a file .xls or .xlsx . The excel sheet has a table...
asked by 17.10.2015 / 22:49
0
answers

Open and read an Excel spreadsheet by Lazarus Using OLE

The code below works perfectly in Delphi, but when I ported to Lazarus, the code compiles without problems, but at the time of execution an exception occurs and the program is closed. function TFMain.AbrePlanilha(NomePlan: String): Boolean; be...
asked by 10.07.2015 / 23:34
1
answer

Macro to access website with login

I run a daily routine to access the Serasa site and make the CNPJ query. I need to develop a macro to access this Serasa site, log in and then the query, and then throw the information into Excel. Detail: I have already developed the macro to ac...
asked by 26.12.2014 / 12:09
0
answers

Organizing data EXCEL

My goal is to do Cubic Spline interpolation. For this I am organizing my data as follows: Imadeasimplemodification.IcalculatedtheusefuldaysbetweenthedayofcolumnBandthedates.ForthedatesthathavenovalueIdonotcareabouttheusefuldays.SoIgotthis: T...
asked by 24.07.2015 / 00:07
0
answers

Handle Decimal Values in EXCEL + VB

I have an application that provides a webservice (ws) (java) but I need to transport data to an excel sheet and print, my problem is this, when I get the values of ws depending on the reginal setting of the operating system, different formats Ex...
asked by 24.04.2015 / 16:49
0
answers

MySQL For Excel and options to import Excel table into MySQL

I'm trying to import a database that is in the format of Excel to MySQL. I was trying with MySQL for Excel, launched the same company. As you can see in the image below it is already installed: InmyExcelnothingappears,intheexamplethatha...
asked by 07.01.2015 / 12:27
0
answers

Add line automatically

I wanted a sql script or excel function that runs the line and when I find "Out of Compliance" add me a new line Name Food from Approved Source (C) Food Protected from Contamination (C) 16 HANDLES Out of Compliance...
asked by 26.01.2015 / 02:29
1
answer

Check if an item in a ListBox has been selected

I have a ListBox1 q list of a ChckBox1 checkbox in a UserForm. I want to enable or disable the checkbox ( CheckBox1.Enabled = True/False if any items in the list are selected. The checkbox is disabled initially, but if so...
asked by 27.04.2017 / 22:11