Sha256: 43b43bc2f635a441bcc7139343d403f9fbcd9328e9dd8fb09c9626f06dc053b1
Contents?: true
Size: 1.37 KB
Versions: 19
Compression:
Stored size: 1.37 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestDateExamples01 < Minitest::Test
def setup
setup_dir_var
end
def teardown
@tempfile.close(true)
end
def test_date_examples01
@xlsx = 'date_examples01.xlsx'
workbook = WriteXLSX.new(@io)
worksheet = workbook.add_worksheet
worksheet.set_column('A:A', 30)
number = 41333.5
worksheet.write('A1', number) # 413333.5
format2 = workbook.add_format(:num_format => 'dd/mm/yy')
worksheet.write('A2', number, format2) # 28/02/13
format3 = workbook.add_format(:num_format => 'mm/dd/yy')
worksheet.write('A3', number, format3) # 02/28/13
format4 = workbook.add_format(:num_format => 'd\\-m\\-yyyy')
worksheet.write('A4', number, format4) # 28-2-2013
format5 = workbook.add_format(:num_format => 'dd/mm/yy\\ hh:mm')
worksheet.write('A5', number, format5) # 28/02/13 12:00
format6 = workbook.add_format(:num_format => 'd\\ mmm\\ yyyy')
worksheet.write('A6', number, format6) # 28 Feb 2013
format7 = workbook.add_format(:num_format => 'mmm\\ d\\ yyyy\\ hh:mm\\ AM/PM')
worksheet.write('A7', number, format7) # Feb 28 2013 12:00 PM
workbook.close
compare_for_regression(
['xl/calcChain.xml', '\[Content_Types\].xml', 'xl/_rels/workbook.xml.rels'],
{}
)
end
end
Version data entries
19 entries across 19 versions & 1 rubygems