Questions tagged as 'excel'

Tagged questions
1
answer

How to copy multiple excel files into an access 2010 database using vba [closed]

I'm new to VBA programming. I need a vba code in excel that copies several excel files to an access table.     
asked by 18.05.2016 / 20:41
1
answer

Turning to decimal in Excel

I have a spreadsheet in which the width and height length are as follows: 0,07 (example) I need it to look like this: 7 (example) How do I do this in all cells at once? Thanks     
asked by 01.06.2016 / 18:05
1
answer

Create JSON with Hierarchy through Excel

I have a table with a tree of products. Category, Group and Subgroup. When I export json to excel, the file exits without hierarchy: As in this example: [ { "id_cat": 4, "desc cat": "Acessorios para Veiculos", "id_gr": 1,...
asked by 03.02.2016 / 01:37
1
answer

Macro to delete filtered table row

I created a table with data from an account balance and I am making a macro to select only a few values. A macro assignment would filter all zeroed values into one of the columns to exclude the rows of those accounts that had no movement. Aft...
asked by 21.08.2015 / 23:26
1
answer

Export XLS content in WordPress admin

I need to export specific content to XLS within the administrative area, and I'm using the following code: $arquivo = 'planilha.xls'; $html = ''; $html .= '<table>'; $html .= '<tr>'; $html .= '<td colspan="3">Planilha teste&...
asked by 15.07.2015 / 00:39
1
answer

Export table contents to an Excel file

I would like to know if it is possible to create a function in PHP and / or Javascript that allows exporting the contents of an HTML table (table inside a div) directly into an Excel file. I'm trying to take advantage of a function created fr...
asked by 17.07.2015 / 16:17
1
answer

Convert EUR-US and USA-EUR currency formats into Excel

My problem: Convert a Range Excel with currency format (USD) into (EUR) and vice versa.    Format USD 123,456,789.00       Format EUR 123 456 789,00 I tried to code a replacement in VBA but I'm a newbie to these things. Can anyone hel...
asked by 13.03.2015 / 19:20
1
answer

Formula Excel Custom List

Hello, I'm creating a spreadsheet and I have a problem. Imagine that a tournament is taking place. To control this tournament I have several tabs, January, February, March, etc. Within each tab I have the names of the tournament participants,...
asked by 30.01.2015 / 22:42
1
answer

How to use AutoFit in C #?

I'm exporting data to an Excel spreadsheet and I'm not able to use AutoFit, could anyone help me? Code: public void exportarExcel(InformacaoDB info, string nomeArquivo) { Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft....
asked by 27.01.2015 / 14:27
1
answer

How to pass data from a Dataset to an Excel C # worksheet?

I read sheet by sheet of a sheet, and I stored it in a DataSet . I'm having trouble passing this DataSet data to another worksheet. Can someone help me ? I have the second code: conn.Open(); string strConexao = string.Form...
asked by 11.09.2014 / 14:56