Questions tagged as 'excel'

Tagged questions
1
answer

How to generate Microsoft Excel spreadsheets in .NET Core?

I need to generate Microsoft Excel spreadsheets through .NET Core , is there any library that does this? In my searches I could only find Microsoft's own Open XML SDK , but support for .NET Core is still under development.     
asked by 26.11.2016 / 23:11
1
answer

PHPExcel generates corrupted .xslx file

I want to generate a .xlsx file, with the records that were not imported, from another table .xlsx , however I can generate the .xls file without problems, when I try to generate .xlsx , Excel warns that the file is cor...
asked by 20.01.2017 / 13:39
3
answers

Extracting text with VBA

I need to create a macro in EXCEL that goes to a cell that has a text, and brings me a piece of this text. The problem is that the text has no pattern, just know that somewhere in this text it will be something like NAME: and EMAIL:...
asked by 29.12.2016 / 21:50
1
answer

How to separate text code

Hi good afternoon person, how are you? I have a question that I would like to know if you can assist me, please: I have a .txt file, which contains more than 1000 lines, I need to separate the code from the text .... I explain myself better...
asked by 21.09.2016 / 19:45
1
answer

Join duplicate names in a single row

I have this worksheet: IhaveinthespreadsheettheclientELISMARCARLOSRODRIGUESDAMATA,whomade3purchases,twoon10/08/2014andoneon20/08/2014.WhatIneedistoconsolidateallpaymentsonthesamedateonthesameline,ie,looklikethis: The two installments on Au...
asked by 20.11.2014 / 13:12
1
answer

IP Control with Excel + VBA

I'm building some functions for analyzing a table of IPs. I just used VBA for the first time in my life and in my searches I did not find anything that could help me. I need to create a function that searches for the least number that does no...
asked by 08.08.2014 / 01:37
1
answer

Excel button to choose

I want to know if it's possible with buttons or list or with some formula. For example I have a list with names of countries (Portugal, Spain, Brazil) and I want the other list to show me the capitals of these countries. Example: I choose...
asked by 14.07.2014 / 13:53
1
answer

Validate field in VBA

In Mozambique there is a unique tax identification number (nuit), and this number takes 9 digits. How would an application validate nuit under the following conditions? If there are more (+) or less (-) than nine (9) digits, say "nuit inval...
asked by 10.06.2014 / 11:16
1
answer

How to calculate delay in days in Access

Today I use the formula =DIAS(HOJE();H2) to calculate the delay time in Excel: But this source I extract from Access, does anyone know the syntax to mount this formula in Access?     
asked by 04.12.2018 / 13:16
1
answer

How do I split a chart bar into "%" in Excel [closed]

Good morning, I have a chart that represents a total amount of reasons of delay of 4 companies. in total. Does anyone know how I can split the bars, to represent how much each company represents in total delays? If necessary send the file...
asked by 03.12.2018 / 13:44