FilesExpand file tree

 main

/

cli.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

75 lines (63 loc) · 2.32 KB

 main

/

cli.py

Copy path

Top

File metadata and controls

• Code
• Blame

75 lines (63 loc) · 2.32 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

"""Command-line interface for excel-diff."""

from __future__ import annotations

import argparse

import sys

from pathlib import Path

from . import __version__

from .differ import diff_files

def _parse_args(argv: list[str] | None = None) -> argparse.Namespace:

parser = argparse.ArgumentParser(

prog="excel-diff",

description="Compare two CSV/Excel files and report what changed.",

epilog="Guides & tutorials: https://python-excel-automation.com",

)

parser.add_argument("old", help="The original/baseline file.")

parser.add_argument("new", help="The updated file to compare against it.")

parser.add_argument(

"-o",

"--output",

help="Write a highlighted diff workbook to this .xlsx path.",

)

parser.add_argument(

"-k",

"--key",

help="Match rows on this column instead of by position.",

)

parser.add_argument(

"--exit-code",

action="store_true",

help="Exit with status 1 when there are differences (handy in CI).",

)

parser.add_argument("--version", action="version", version=f"%(prog)s {__version__}")

return parser.parse_args(argv)

def main(argv: list[str] | None = None) -> int:

args = _parse_args(argv)

try:

result = diff_files(args.old, args.new, output=args.output, key=args.key)

except (ValueError, FileNotFoundError) as exc:

print(f"error: {exc}", file=sys.stderr)

return 2

s = result.summary

if not result.has_changes:

print("No differences found.")

else:

print(

f"Δ {s['rows_added']} added, {s['rows_removed']} removed, "

f"{s['cells_changed']} cell(s) changed"

+ (

f", {s['columns_added']} col(s) added, {s['columns_removed']} col(s) removed"

if s["columns_added"] or s["columns_removed"]

else ""

)

)

for c in result.changed[:10]:

print(f" • row {c['row']} · {c['column']}: {c['old']!r} → {c['new']!r}")

if len(result.changed) > 10:

print(f" … and {len(result.changed) - 10} more changed cell(s)")

if args.output:

print(f"Wrote {Path(args.output)}")

if args.exit_code and result.has_changes:

return 1

return 0

if __name__ == "__main__":

raise SystemExit(main())