Questions tagged as 'excel'

Tagged questions
2
answers

Printing in excel with php and jquery

I'm trying to print to excel a query presented in table with php and jquery in the <tbody> tag. However it did not work. He presented in excel a wrong result with all result HTML in a single cell. COULD YOU HELP ME? I found the s...
asked by 03.07.2014 / 19:53
1
answer

Choose a file in a folder and save it as text automatically

I want to make a VBA code that opens a specific spreadsheet and saves it as tabbed text. I'm having this formulated code Sub gerararquivotxt() Dim intChoice As Integer Dim strPath As string 'permitir escolher só um arquivo Application.FileD...
asked by 17.11.2014 / 19:29
1
answer

How to display registered values in one Google Drive worksheet in another through query by JS

I have a table in Google Drive and I want to use Scripts to do what I want to stay in a more dynamic way. On Page2, I have the "Result", "Delay" and "Arrival" fields with their results filled out below, I want to create a page on Page1 in a f...
asked by 25.02.2014 / 15:23
2
answers

Export data from an array to a table using VBA

In Sheet1 I have a table with only the Header of each column but blank values, I run a VBA that creates an Array that has the same number of columns in the table. Is there any way to export all values from this array to the Excel table at...
asked by 10.10.2014 / 23:17
1
answer

Export Excel Data PHP Variable Workbench

I'm having second thoughts about generating an excel with the query. <?php include("conectar.php"); $id = $_GET['id']; $arquivo = 'Não autorizado .xls'; First question: In the $ share part, can I put a variable to rename the file? // -...
asked by 28.05.2014 / 10:45
0
answers

Export HTML table to Excel

I have this page in PHP that lists all my records, I'm trying to export it to Excel, but all the records come out in just one column. <?php require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/xajax.inc.php'; $url = "http://".$_SERVER["SERVE...
asked by 27.10.2018 / 02:21
1
answer

How to group data and list another table in excel

Hello. I have a shopping chart with several records and wanted to create a list / table next to it that contained the place of purchase and the front the total amount spent in that store. here is an example of what I want. <table>...
asked by 16.07.2018 / 13:02
0
answers

Formula Optimization

Could you help me find a way to optimize the formula below? The spreadsheet has more than 125,000 lines with this formula in some 4 columns and is generating a lot of slowness to process the information and even to open it. =SE( $D125883="...
asked by 09.03.2018 / 15:22
0
answers

Apache POI - How to put Hyperlink in an image in Excel?

This is the method I use to put images in Excel: public void insertIcons(String URL, Sheet sheet, int colBegin, int colEnd, int rowBegin, int rowEnd) { try { InputStream iconInput = new FileInputStream(URL); byte[] byteTran...
asked by 07.01.2018 / 19:28
1
answer

Error inserting data from an excel file into sql

I have a problem when I insert data from the excel file into the database because in a field I am inserting it says that it is not of type time and does not let insert, but in the Excel file the text is written is only hours or is time...
asked by 02.11.2017 / 17:35