Questions tagged as 'excel'

Tagged questions
0
answers

How to import an EXCEL to MYSQL using Codeigniter? Tutorial

I recently asked about this topic on this website, and since I managed to import the data correctly, and after almost a week searching the Internet, I decided that it would be good to publish a question about it, since the biggest part of inform...
asked by 19.09.2017 / 01:11
0
answers

Callout VBA word

I'm doing a macro in Visual Basic for word. I already have this code: Set Callout = ActiveDocument.Shapes.AddCallout( _ Type:=msoCalloutThree, _ Left:=170, Top:=119.5, Width:=widthsize1, Height:=heightsize1) Callout.Callout.Accent = msoFalse...
asked by 19.09.2017 / 08:22
0
answers

Manipulate a UserForm in Excel with Python [closed]

I have a button on an excel sheet that calls a form with several things like radio buttons, listbox, etc. I'm looking for ways to manipulate the comboboxes inside the form with a Python script but I have no idea how to do it. I have been p...
asked by 15.09.2017 / 05:16
1
answer

Python xlsx loops, repeat actions

I have the following problem: With the code I will paste below, I charge my .xlsx. In it I have columns and in them different values. I add one more column that will have a specific value for each row. My problem is that I do it individually...
asked by 24.08.2017 / 10:36
1
answer

Format of text to message body

I'm doing a macro in Excel which is used to send a meeting with Outlook, everything works fine but in the body of the message I want the text to be formatted, for example to put the text of colors, with bold, etc. Which I have not yet achieved,...
asked by 10.08.2017 / 21:37
0
answers

How to export to multiple worksheets in an ETL using Visual Studio [closed]

I am trying to export an excel file with two tabs or worksheets in an ETL using Visual Studio. I can not find anything on the web to help me. I attach the Controlflow and the Dataflow. Thank you!     
asked by 02.06.2017 / 16:29
0
answers

Export Tables from a DB to an Excel with one sheet per table

Hello gentlemen, I'm looking for Export the Tables of a DB (No matter the engine, I care that you can) to an Excel with one sheet per table . Example: a single file called gastos.csv that inside contains a sheet for each table that...
asked by 04.05.2017 / 20:13
0
answers

How to modify the value or link of a .href attribute from vba excel?

In my company we started using Altiris from Symantec At this moment I am in charge of the massive load of hardware inventories. I upload the information using Excel - VBA. The data loading formulations are in HTML and JavaScripts format In a...
asked by 03.05.2017 / 20:48
1
answer

How to export a complex JSON response to XLS, with JavaScript?

Hello everyone! Do you know of any tool that can generate an XLS from a JSON response? I intend to make a query, without showing it in a table, and based on it elaborate the XLS as customizable as possible (similar to PHPEXCEL, where you h...
asked by 14.03.2017 / 00:43
0
answers

Download Server Excel File

To download an excel file, This is my code but just send me an alert with an "OK", use a generic Handler. public void ProcessRequest(HttpContext context) { System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;...
asked by 07.07.2017 / 17:22