MP

Hi everybody,

there is a way to read the Excel File properties such as "Creation Date" or "Author" or other properties?

 

Thanks

Marco

 

by Nikita Martyanov
Posted on Wed, 10/11/2017 - 21:51

Hi Marco,

you have to use OPCPackage class if your Excel File has Office Open XML format (.xlsx). Here's some code and I've attached script you can download and use.

var file = Dialogs.getFilePath("","xlsx",null,"Select file",0)[0]
var baData = file.getData()
var fis = new java.io.ByteArrayInputStream(baData)
var xlsxFile = org.apache.poi.openxml4j.opc.OPCPackage.open(fis)
var author = xlsxFile.getPackageProperties().getCreatorProperty().getValue()
var creationDate = xlsxFile.getPackageProperties().getCreatedProperty().getValue()
Dialogs.MsgBox(author+"-"+creationDate)

 

If you need more file properties you can find them in OPCPackage specifications.

File attachments
0
by Nikita Martyanov
Posted on Thu, 10/12/2017 - 07:34

In reply to by billie1989

I'm sorry. I forgot to close fileinputstream. Add line

fis.close()

after previous code.

0
by Robert Goldenbaum
Badge for 'Question Solver' achievement
Posted on Mon, 10/16/2017 - 09:29

Nice - thanks for the information...

 

BR Robert

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock