Questions tagged as 'excel'

Tagged questions
1
answer

Create dynamic columns depending on a checkbox - excel 2007

I have a simple table with 4 values and a checkbox for each of them: Sellers: | João | Antonio | Paulo | Carlos On another excel sheet, I have a table where I can add rows, and where each row has Month-Year. I'm wanting the columns to be t...
asked by 02.06.2014 / 11:26
1
answer

Open Excel file in BINARY_SAFE

I would like, in PHP, to open an existing XLS worksheet, insert data into columns, save and close the file. Is there any function or API for this type of handling, which opens the file in BINARY_SAFE and allows me this kind of manipulatio...
asked by 03.04.2014 / 22:10
1
answer

Perform UNPIVOT in Excel to Import in Access

I have a table with the following format: Asthefirstcolumnandthefirstrowarecodefields,IneedtobeinthefollowingformatforimportintoMSAccess: It is possible to do it manually, but since the table is VERY extensive, I wonder if you have any way...
asked by 11.04.2014 / 14:03
1
answer

Create XML with Excel, date field formatting problem

I have an Excel spreadsheet, generated by SAP with a date field. I need to convert this spreadsheet to XML. I do XML mapping through Excel, but I can not get it to export the date field as a date, the equivalent number always appears as below...
asked by 01.08.2014 / 18:03
0
answers

Recursive errors generating a word file from the fields of an Excel worksheet (VBA)

Good afternoon, I never programmed in VBA but I found myself in a need where I need to generate a word document from some cells of a worksheet in excel, after searching several websites on the internet I was able to make a script that works, the...
asked by 28.11.2018 / 17:28
1
answer

Is it possible to pull information from a specific location on a site in excel?

My question is the following ... I have a TopDesk called. I would like to pull information like opening and closing date and status (open, closed, resolved) ... I would like to know if in excel I have to do this procedure. It's the same conce...
asked by 29.11.2018 / 11:30
0
answers

Opening excel in php on different servers

I have an excel file that stays on a server, for example: \192.168.0.1\arquivos\teste.csv And I have an Apache server on another server, for example: \192.168.0.2\www\index.php I want the apache server to put a button to open the file...
asked by 06.12.2018 / 19:12
0
answers

paint cell through an "ok" in another cell [closed]

Good morning, I do not know if you will understand my reasoning, but come on ..... I have a cell that has names example: SABRINA (A1), I need to put OK in cell (B1), and after putting "OK", I need the name to be green, so that I know that it...
asked by 28.12.2018 / 13:00
0
answers

Import Excel that does not have default to SQL SERVER with C # [closed]

I have the following scenario: I have an Excel spreadsheet that is provided by several private companies. This worksheet contains social security data. The problem is this: I have columns that refer to company data and columns that refer to the...
asked by 28.12.2018 / 12:10
0
answers

Excel how to compare 4 equal criteria in a table

I have a player characteristics table. I need a formula that checks [TRUE / FALSE] if all of the characteristics were repeated The table is contained in the following range: $ R $ 3: $ X $ 2004 The criteria range is: $ S $ 3: $ V $ 20...
asked by 24.12.2018 / 15:25