web stats
export to excel file - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 06-14-2018, 06:34 AM
jurryt laleeuwe jurryt laleeuwe is offline
What's HL7?
 
Join Date: Jun 2018
Posts: 2
jurryt laleeuwe is on a distinguished road
Default export to excel file

Hi,

I'm new to Mirth and i'm need some help.
Is it possible to write the data from a HL7-file to an Excel.

I found that it is possible to read an Excel with the JExcel Api but i dit not find information about writing to Excel.

is it possible ?


Thank you all in advance!
Reply With Quote
  #2  
Old 06-14-2018, 08:47 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 252
agermano is on a distinguished road
Default

Is Excel format an absolute requirement? I'm sure it's possible, but it's much easier to write a csv file instead that can be opened by Excel.
Reply With Quote
  #3  
Old 06-14-2018, 10:21 AM
jurryt laleeuwe jurryt laleeuwe is offline
What's HL7?
 
Join Date: Jun 2018
Posts: 2
jurryt laleeuwe is on a distinguished road
Default

Unfortunately it is a requirement.
Reply With Quote
  #4  
Old 06-14-2018, 11:49 AM
stormcel stormcel is offline
OBX.3 Kenobi
 
Join Date: Mar 2010
Location: Phoenix
Posts: 111
stormcel is on a distinguished road
Default

A quick search turned up SimpleExcel.js

SimpleExcel.js
Reply With Quote
  #5  
Old 06-14-2018, 12:11 PM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 252
agermano is on a distinguished road
Default

Also,
Apache POI https://poi.apache.org/spreadsheet/index.html
SheetJS https://github.com/SheetJS/js-xlsx
Reply With Quote
  #6  
Old 06-14-2018, 12:28 PM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 252
agermano is on a distinguished road
Default

Quote:
Originally Posted by stormcel View Post
A quick search turned up SimpleExcel.js

SimpleExcel.js
So, I looked at that because it seemed fairly simple to use, but it doesn't actually implement any excel functionality, so don't waste your time with this one.
Reply With Quote
  #7  
Old 06-15-2018, 01:47 AM
nicovn nicovn is offline
OBX.2 Kenobi
 
Join Date: Oct 2006
Location: Belgium
Posts: 61
nicovn
Default

Hi Jurryt,


You can use Apache POI to read/write Excel files from Mirth Connect

https://poi.apache.org/spreadsheet/index.html


Best Regards

Nico
__________________
Nico Vannieuwenhuyze

Amaron.be
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 03:28 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Mirth Corporation