Questions tagged as 'excel'

Tagged questions
1
answer

How to get only one cell from a CSV file with PHP?

How do I get just one row from a specific column? In the code below it shows me all the rows and all the columns it has in the CSV file. I just want a specific cell. Example: Coluna B - Cars Line 2 - Fox Line and column cell - B2 I wa...
asked by 30.06.2017 / 14:47
0
answers

Query with return #num! for string columns in excel

I made a query in excel that when running it in VBA a result was generated. Among the generated columns, one that was text appeared with #num! in all values that were not empty before. I think excel understood that column was numeric even tho...
asked by 04.07.2017 / 02:59
1
answer

Improve performance by generating excel spreadsheet

I'm using this generated NPOI to create the excel worksheets and I'm facing the following problem: The generated worksheet has 300 lines and takes 1 minute to generate and sometimes the Exception of type 'System.OutOfMemoryException' was...
asked by 16.06.2017 / 16:24
1
answer

How to run macro with project locked?

Hello, I have a spreadsheet whose project has a password, but I want the macros to work and if the user tries to enter the macros they will have to enter the password (which I put in the project). I put a code that unlocks the spreadsheet upo...
asked by 21.06.2017 / 16:17
2
answers

Excel converts Macro into formula?

Can I use a simple macro line in a formula without using the macro editor in VB? I want to get a value of a cell always from the leftmost tab of the active tab, how could this be done only via formula? I found something like this in a foru...
asked by 04.07.2017 / 14:14
1
answer

Edit Excel worksheet with C # in Microsoft Azure

I have a web application that reads an excel spreadsheet and imports the cell values into the database automatically. I am using COM, so it is necessary on the machine Microsoft Excel installed. When compiling locally it works without problems....
asked by 08.06.2017 / 01:46
1
answer

Excel vba: Saving data from a spreadsheet in .txt format

Good afternoon. I have the macro below and it already does almost what I want (it creates a txt file with the data of the Historico worksheet, always rewriting the file, that is, it does not create several copies), however this History sheet con...
asked by 22.05.2017 / 20:03
0
answers

Total / Sum of columns stacked in Excel chart

I would like to know how to insert the total of stacked columns into the pivot chart in excel. This column exists in the dynamic table but it does not appear in the chart. In the photo below I inserted the total in a photo editor, for you to...
asked by 27.05.2017 / 02:54
1
answer

How to load an Excel table and transform it into an HTML table using JavaScript?

I want to create a button to load an xls or csv file and make this Excel table into an HTML table, how can I do this using JavaScript? Please ...     
asked by 17.05.2017 / 22:08
1
answer

Error generating file

I have a method that generates a file, this method is actually generating the file, I have another method inside my service that returns the file for download and for this I return a List until then I return that list with bytes for my controler...
asked by 18.05.2017 / 02:19