Skip to content

write data validation to excell template file

Bitbucket Importer requested to merge bitbucket/declined-pr-167 into branch/default

Created originally on Bitbucket by hamzafar_89 (Hamza Zafar)

Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.

  • Add 2.5 branch and remove 2.6 compatibility code.

  • Remove deprecated methods.

  • Remove more legacy.

  • Open file as binary to avoid encoding problems.

  • Remove some deprecated methods and code.

  • Fix test because required import was removed.

  • Fix failing tests.

  • Remove Python 2.6 compatibility code.

  • Backout changeset 2df5356d3363

  • Update comment, not just Python 2.6 compatible.

  • Switch to using XPath to search for tags.

  • Always need root element.

  • Correct code for checking whether content type has been added. Reenable skipped test.

  • Correct mime type.

  • Adjust path and file name to match other conventions.

  • Adjust tests for new comments paths.

  • Remove API for deprecated module.

  • Remove API for deprecated module.

  • Preserve workbook calculation properties.

  • Run tests quietly and don't bother generating coverage info.

  • Add a test for sheet names containing commas.

  • Quote worksheet names that contain commas.

  • Rely on the regex to split multiple definitions. Resolves #759 (closed)

  • Update docs.

  • Initial import of Laurent's code. Slightly modified: let's focus initially on the cells.

  • Fix failure

  • Remove additional and never documented options. The anchor itself can be passed in when adding to a worksheet. Bounding box function kept in case anyone wants to use it.

  • Move anchor creation to a separate function so that it can also be used for images.

  • Adjust code for handling anchors.

  • Remove unused code: Drawings no longer embedded, anchors must be provided.

  • Images are sized in pixels.

  • Correct size and width Default to putting images on A1

  • If a PIL image is passed in without a format then default to PNG

  • Add tests for creating anchors for images and charts.

  • Add naive tests for adding charts and images.

  • Check we have an anchor.

  • Mark test as requiring PIL

  • Markers aren't callable.

  • Add an option for working with iso dates and times. Removes all uncertainties and inconsistencies caused by Excel's serial format.

  • Break tests down to methods.

  • Do not convert to serial on binding.

  • Do not create a new plot area when writing and add a check to stop adding existing charts when saving multiple times. Resolves #776 (closed)

  • Update docs

  • Introduce dedicated type for dates and times and convert to datetime when reading.

  • Make the function more generic.

  • Allow serialisation as an ISO datetime.

  • Assign to local variable which is used at the end of the code branch. Might want to refactor into sub-methods.

  • Parametrise tests

  • Expand docstring

  • Convert to a raw string and verbose for readability.

  • Add named groups to regex

  • Make regex more flexible to allow it to handle dates, times and datetimes.

  • Add test for regex matching.

  • Rename functions to refer to ISO standard.

  • Use to_ and from_ for functions to be more consistent with the rest of the package

  • Add handling for datetime cells.

  • Remove non-ascii § symbol for Python 2

  • Add note about ISO 8601 support Resolves #674 (closed)

  • Add heuristics to infer whether it is date, datetime or time (including timedelta / duration) when reading files. Also adjust regex to exclude colours only. Incidentally resolves #779 (closed)

  • Update docs.

  • Use some known unicode to avoid having to work out the code points for Chinese characters.

Merge request reports