title: python: reportlab: excel table did not fit with size
body: <p>I try to read and print an Exceltable (with text, umlauten $%°() ). I make the read in with xlrd and print it with reportlab. The result is bad. My table did not fit with the sitze, the text did not have line breaks for each column and therefore column width is to wide. Is there a way to force reportlab to do this?
  Here is my code:</p>
  
  <pre><code>&gt;import xlrd
  &gt;wb = xlrd.open_workbook("test.xls", 
  &gt;encoding_override="UTF-8")#"iso-8859-1")
  &gt;wb.sheet_names()
  &gt;sh = wb.sheet_by_index(0)
  &gt;
  &gt;rows = []
  &gt;for row_number in xrange(sh.nrows):
  &gt;     rows.append(sh.row_values(row_number))
  &gt;
  &gt;data=[row for row in rows]
  &gt;
  &gt;
  &gt;from reportlab.lib import colors
  &gt;from reportlab.lib.pagesizes import letter
  &gt;from reportlab.platypus import SimpleDocTemplate, Table, TableStyle, Paragraph
  &gt;from reportlab.lib.styles import getSampleStyleSheet
  &gt;from reportlab.lib.units import inch
  &gt;from reportlab.platypus.paragraph.cleanBlockQuotedText
  &gt;styles = getSampleStyleSheet()
  &gt;doc = SimpleDocTemplate("simple_table.pdf", pagesize=letter)
  &gt;
  &gt;elements = []
  &gt;
  &gt;t=Table(data)
  &gt;elements.append(t)
  &gt;doc.build(elements)
  </code></pre>
  
  <p>Did somebody see my mistake? Thanks</p>