Questions tagged as 'office'

Tagged questions
1
answer

Error using JavaMail with Office365 account

I have a Java class that works perfectly for sending emails through a Gmail account. However, even using the recommended settings to send an SMTP email with Office365, an error is returned. The error is as follows:    exception javax.servl...
asked by 31.05.2015 / 17:41
0
answers

powershell script for offline office key decryption

I removed the "2007" office key from a "dead" PC that was on the registry Now I was modifying the popular "Search-RegistryKeyValues" script, to directly pass the value to decrypt. But I'm not sure what to "give". My question is on the line...
asked by 01.07.2015 / 18:33
1
answer

PROCV between two worksheets

The result that I show in the authors column of the production worksheet is the name of all authors who have written that discipline. I'm using the following function =PROCV(C8;'Remanejamento'!C3:D55;2) but it does not return all the...
asked by 16.08.2018 / 20:28
1
answer

Apache POI: how to tell if a spreadsheet has come to an end?

I'm developing a personal project, and for this I'm using Java along with the Apache POI to read XLS files, how can I tell if the spreadsheet has come to an end? Thank you!     
asked by 10.02.2018 / 04:23
1
answer

xlrd open files in xls format?

I'm sorry for my ignorance on the subject, but I'm developing a Python script that reads Excel files to get certain information in those, and for this I'm using xlrd, I wanted to know if xlrd is able to read xls files too, which is an older Exce...
asked by 17.12.2017 / 18:44
2
answers

Generate an excel file from a data grid C #

I'm trying to generate an excel file from a datagrid, and this is generating the following error: Anunhandledexceptionoftype'System.InvalidCastException'occurredinEletronicTaxNotes.exeAdditionalinformation:TheCOMobjectoftype'Microsoft.Office.In...
asked by 02.05.2017 / 15:44
0
answers

Execute the quartile formula in certain months

I have a table with hundreds of values and these are divided between product name and date of sale. I've filtered the type of product (in the example, blouses and shirts) and now I want to get the quartiles for each month. Example Nome...
asked by 28.09.2018 / 16:50
1
answer

VBA code to delete line

Well, I have a code that checks the line if there is a word or phrase and deletes the line: If Mid(Cells(i, 10), 1, 50) <> "Defeito" Then Rows(i).Delete Shift:=xlUp But in the spreadsheet there are phrases like "Defect + broadband" or...
asked by 07.05.2018 / 21:12
1
answer

VBA macro for Exel - copy data from one sheet to another with one condition

Live personal, I am completely new to VBA and programming. I need help to build a macro for Excel. Context: In the Excel workbook that is in the following link, I want to develop a VBA macro that fills in the "transatas", "finished" and "wa...
asked by 18.09.2017 / 15:06