Questions tagged as 'excel'

Tagged questions
0
answers

Hide and show excel sheets from python (hide and unhide)

I'm trying to hide and show (hide and unhide) some excel sheets using openpyxl, but I can not find a way to do it. Someone has some idea of how it is done, or maybe using some other library. Thanks     
asked by 16.02.2017 / 17:27
0
answers

Sort Excel File Columns

I would like to know how I can command the columns of an Excel with VB.NET, for the moment I open the Excel with Interop, now I would like to sort the columns since I have them for the moment as shown in the image. The result I want to...
asked by 21.02.2017 / 23:35
1
answer

Compare two tables in Mysql [closed]

I am uploading two files from Excel to a JSP to save it in MySQL the first file with its columns: |------------------| | Archivos_nombres | |------------------| | identificación | | nombre_j | | nombre_n | |-----------...
asked by 12.01.2017 / 15:53
1
answer

Create filter in excel from C # using Interop

In the header I want the filter to appear once the document has been created in excel. I have tried several options and combinations, but NO have worked for me. Option 1: oRng = oSheet.get_Range("A1", "J1"); oRng.AutoFilter("1",...
asked by 27.12.2016 / 12:59
1
answer

Error in date Laravel Excel

I'm using the Laravel Excel library and so far I've done well in many different file formats, etc ... The thing is that now I have the following case: In the excel file they pass me a date in dd / mm / yyyy format and without treating it or...
asked by 07.10.2016 / 14:16
0
answers

VBA macros excel [closed]

I have a sheet with ActiveX buttons; Each button has a password to open a specific sheet. When I click on any button it takes me to: Private Sub Alpujarra_Click() formContra.Show End Sub Private Sub btnAceptar_Click() Clave = txtClav...
asked by 25.08.2016 / 21:07
1
answer

Laravel Excel Structure (Importing File)

I am using the Laravel Excel library and I have been reading the documentation but it does not say anything to read the excel from a certain row number, that is, I have the first 6 lines of the excel with information and the "title" of each co...
asked by 17.05.2016 / 10:48
1
answer

How to calculate how many items are associated with an ID

I'm working on excel and in one of the formulas I have to do, I calculate how many different items are associated with a specific ID. I have the following columns ID Item OPX-0020433077 Continuity Services OPX-0020433077...
asked by 04.12.2018 / 15:21
1
answer

Any advice to connect an SSAS cube with an excel pivot table using c #?

I am with a development project in which I have to connect by means of C # in Visual Studio a cube to an Excel pivot table, in which I can visualize the information lodged in the cube. I was wondering if anyone has done it or has any idea how to...
asked by 07.09.2016 / 01:29
2
answers

Name Excel sheet with specific date format

I would like to name the sheets of Excel with a specific format "name of the day corresponding to the date" and "date entered by the user" , it works for me well the code except for the part of the name of the day, always shows me "Sa...
asked by 05.03.2017 / 10:55