# coding:utf-8
'''
Created on 06.08.2014

@author: v.popov
'''

from com.ziclix.python.sql import zxJDBC
from com.ziclix.python.sql import PyConnection

from java.io import ByteArrayInputStream, InputStream, OutputStream, ByteArrayOutputStream, \
    FileOutputStream, FileInputStream, File
from ru.curs.celesta.showcase.utils import XMLJSONConverter
import json
from java.util import ArrayList
from org.xml.sax import InputSource
from java.io import StringReader
import os
from ru.curs.flute.xml2spreadsheet import XML2Spreadsheet


def printToExcel(dataXml, excel_template, xml_descriptor, resultstream):
    u'''Печатаем документ в excel'''

    journalspath = os.path.dirname(os.path.dirname(__file__))
    reportspath = u'%s/reports' % journalspath

    descriptor = File(u'%s/%s' % (reportspath, xml_descriptor))
    template = File(u'%s/%s' % (reportspath, excel_template))

    data = ByteArrayInputStream(dataXml.encode('utf-8'))
    try:
        XML2Spreadsheet.process(data, descriptor, template, False, resultstream)
    finally:
        resultstream.close()