Python create_sample_file1 Examples

Example #1

File: test_multiple_sheets.py Project: ChiangFamily/pyexcel

    def setUp(self):
        """
        Make a test csv file as:

        a,b,c,d
        e,f,g,h
        i,j,1.1,1
        """
        self.testfile = "testcsv.csv"
        create_sample_file1(self.testfile)

Example #2

    def setUp(self):
        """
        Make a test csv file as:

        a,b,c,d
        e,f,g,h
        i,j,1.1,1
        """
        self.testfile = "testcsv.csv"
        create_sample_file1(self.testfile)

Example #3

File: test_stringio.py Project: castarco/pyexcel

 def test_csv_stringio(self):
     csvfile = "cute.csv"
     create_sample_file1(csvfile)
     with open(csvfile, "r") as f:
         content = f.read()
         r = pe.Reader(("csv", content))
         result=['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
         actual = pe.utils.to_array(r.enumerate())
         assert result == actual
     if os.path.exists(csvfile):
         os.unlink(csvfile)

Example #4

 def test_ods_stringio(self):
     odsfile = "cute.xlsx"
     create_sample_file1(odsfile)
     with open(odsfile, "rb") as f:
         content = f.read()
         r = pyexcel.get_sheet(file_type="xlsx", file_content=content)
         result=['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
         actual = pyexcel.utils.to_array(r.enumerate())
         assert result == actual
     if os.path.exists(odsfile):
         os.unlink(odsfile)

Example #5

 def test_book_stringio(self):
     csvfile = "cute.xls"
     create_sample_file1(csvfile)
     with open(csvfile, "rb") as f:
         content = f.read()
         b = pe.load_book_from_memory("xls", content)
         result = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
         actual = pe.utils.to_array(b[0].enumerate())
         assert result == actual
     if os.path.exists(csvfile):
         os.unlink(csvfile)

Example #6

File: test_reader.py Project: Cassidamius/pyexcel

    def setUp(self):
        """
        Make a test csv file as:

        a,b,c,d
        e,f,g,h
        i,j,k,l
        """
        self.testfile = "testcsv.csv"
        self.rows = 3
        create_sample_file1(self.testfile)

Example #7

File: test_stringio.py Project: mromero107/pyexcel-xlsx

 def test_ods_stringio(self):
     odsfile = "cute.xlsx"
     create_sample_file1(odsfile)
     with open(odsfile, "rb") as f:
         content = f.read()
         r = pyexcel.Reader(("xlsx", content))
         result=['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
         actual = pyexcel.utils.to_array(r.enumerate())
         assert result == actual
     if os.path.exists(odsfile):
         os.unlink(odsfile)

Example #8

    def setUp(self):
        """
        Make a test csv file as:

        a,b,c,d
        e,f,g,h
        i,j,1.1,1
        """
        self.testclass = pe.Reader
        self.testfile = "testcsv.xls"
        create_sample_file1(self.testfile)

Example #9

File: test_stringio.py Project: bdeeney/pyexcel

 def test_book_stringio(self):
     csvfile = "cute.xls"
     create_sample_file1(csvfile)
     with open(csvfile, "rb") as f:
         content = f.read()
         b = pe.load_book_from_memory("xls", content)
         result=['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
         actual = pe.utils.to_array(b[0].enumerate())
         assert result == actual
     if os.path.exists(csvfile):
         os.unlink(csvfile)

Example #10

File: test_stringio.py Project: bdeeney/pyexcel

 def test_csvz_stringio(self):
     csvfile = "cute.csvz"
     create_sample_file1(csvfile)
     with open(csvfile, "rb") as f:
         content = f.read()
         r = pe.load_from_memory("csvz", content)
         result=['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', '1.1', '1']
         actual = pe.utils.to_array(r.enumerate())
         assert result == actual
     if os.path.exists(csvfile):
         os.unlink(csvfile)

Example #11

File: test_stringio.py Project: pyexcel/pyexcel-xlsxw

 def test_ods_stringio(self):
     odsfile = "cute.xlsx"
     create_sample_file1(odsfile)
     with open(odsfile, "rb") as f:
         content = f.read()
         r = pyexcel.get_sheet(file_type="xlsx", file_content=content)
         result = ["a", "b", "c", "d", "e", "f", "g", "h", "i", "j", 1.1, 1]
         actual = list(r.enumerate())
         eq_(result, actual)
     if os.path.exists(odsfile):
         os.unlink(odsfile)

Example #12

File: test_stringio.py Project: schulzsebastian/qgisplugin_spreadsheet

 def test_ods_stringio(self):
     odsfile = "cute.ods"
     create_sample_file1(odsfile)
     with open(odsfile, "rb") as f:
         content = f.read()
         r = pyexcel.get_sheet(file_type="ods", file_content=content)
         result = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
         actual = list(r.enumerate())
         eq_(result, actual)
     if os.path.exists(odsfile):
         os.unlink(odsfile)

Example #13

 def test_xls_stringio(self):
     csvfile = "cute.xls"
     create_sample_file1(csvfile)
     with open(csvfile, "rb") as f:
         content = f.read()
         r = pe.Reader(("xls", content))
         result = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
         actual = pe.utils.to_array(r.enumerate())
         assert result == actual
     if os.path.exists(csvfile):
         os.unlink(csvfile)

Example #14

File: test_sheet_update.py Project: chiyodad/pyexcel

    def setUp(self):
        """
        Make a test csv file as:

        a,b,c,d
        e,f,g,h
        i,j,1.1,1
        """
        self.testclass = pe.Reader
        self.testfile = "testcsv.xls"
        create_sample_file1(self.testfile)

Example #15

 def test_xls_stringio(self):
     testfile = "cute.xls"
     create_sample_file1(testfile)
     with open(testfile, "rb") as f:
         content = f.read()
         r = pyexcel.get_sheet(file_type="xls", file_content=content)
         result = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
         actual = list(r.enumerate())
         eq_(result, actual)
     if os.path.exists(testfile):
         os.unlink(testfile)

Example #16

File: test_stringio.py Project: gamer-007/pyexcel-xls

 def test_xls_stringio(self):
     xlsfile = "cute.xls"
     create_sample_file1(xlsfile)
     with open(xlsfile, "rb") as f:
         content = f.read()
         r = pyexcel.get_sheet(file_type="xls", file_content=content)
         result = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
         actual = pyexcel.utils.to_array(r.enumerate())
         assert result == actual
     if os.path.exists(xlsfile):
         os.unlink(xlsfile)

Example #17

File: test_sheet_update.py Project: Cassidamius/pyexcel

    def setUp(self):
        """
        Make a test csv file as:

        a,b,c,d
        e,f,g,h
        i,j,1.1,1
        """
        self.testclass = pyexcel.PlainReader
        self.testfile = "testcsv.csv"
        self.rows = 3
        create_sample_file1(self.testfile)

Example #18

File: test_stringio.py Project: pyexcel/pyexcel-xlsx

 def test_xlsx_stringio(self):
     testfile = "cute.xlsx"
     create_sample_file1(testfile)
     with open(testfile, "rb") as f:
         content = f.read()
         r = pyexcel.get_sheet(
             file_type="xlsx", file_content=content, library="pyexcel-xlsx"
         )
         result = ["a", "b", "c", "d", "e", "f", "g", "h", "i", "j", 1.1, 1]
         actual = list(r.enumerate())
         eq_(result, actual)
     if os.path.exists(testfile):
         os.unlink(testfile)

Example #19

 def test_csvz_stringio(self):
     csvfile = "cute.csvz"
     create_sample_file1(csvfile)
     with open(csvfile, "rb") as f:
         content = f.read()
         r = pe.load_from_memory("csvz", content)
         result = [
             'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', '1.1', '1'
         ]
         actual = pe.utils.to_array(r.enumerate())
         assert result == actual
     if os.path.exists(csvfile):
         os.unlink(csvfile)

Example #20

def do_book_read_stringio(file_name):
    create_sample_file1(file_name)
    file_type = file_name.split(".")[-1]
    open_flag = "rb"
    if file_type in ["csv", "tsv"]:
        open_flag = "r"
    with open(file_name, open_flag) as f:
        content = f.read()
        b = pe.get_book(file_type=file_type, file_content=content)
        result = ["a", "b", "c", "d", "e", "f", "g", "h", "i", "j", 1.1, 1]
        actual = list(b[0].enumerate())
        eq_(result, actual)
    if os.path.exists(file_name):
        os.unlink(file_name)

Example #21

File: test_stringio.py Project: jayvdb/pyexcel

def do_read_stringio(file_name):
    create_sample_file1(file_name)
    file_type = file_name.split('.')[-1]
    open_flag = 'rb'
    if file_type in ['csv', 'tsv']:
        open_flag = 'r'
    with open(file_name, open_flag) as f:
        content = f.read()
        r = pe.get_sheet(file_type=file_type, file_content=content)
        result=['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
        actual = pe.utils.to_array(r.enumerate())
        assert result == actual
    if os.path.exists(file_name):
        os.unlink(file_name)

Example #22

def do_read_stringio(file_name):
    create_sample_file1(file_name)
    file_type = file_name.split('.')[-1]
    open_flag = 'rb'
    if file_type in ['csv', 'tsv']:
        open_flag = 'r'
    with open(file_name, open_flag) as f:
        content = f.read()
        r = pe.get_sheet(file_type=file_type, file_content=content)
        result = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
        actual = pe.utils.to_array(r.enumerate())
        assert result == actual
    if os.path.exists(file_name):
        os.unlink(file_name)

Example #23

def do_book_read_stringio(file_name):
    create_sample_file1(file_name)
    file_type = file_name.split('.')[-1]
    open_flag = 'rb'
    if file_type in ['csv', 'tsv']:
        open_flag = 'r'
    with open(file_name, open_flag) as f:
        content = f.read()
        b = pe.get_book(file_type=file_type, file_content=content)
        result = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 1.1, 1]
        actual = list(b[0].enumerate())
        eq_(result, actual)
    if os.path.exists(file_name):
        os.unlink(file_name)