Excel to PDF

excel2pdf.go

package main

import (
	"flag"
	"fmt"
	"log/slog"
	"os"
	"path/filepath"
	"strings"

	"github.com/devlights/goxcel"
	"github.com/devlights/goxcel/constants"
)

type target struct {
	p       string // file-path
	a       string // file-abs-path
	c       string // converted file-path (pdf)
	verbose bool
}

func (me *target) abs() string {
	if me.a == "" {
		v, _ := filepath.Abs(me.p)
		me.a = v
	}

	if me.verbose {
		slog.Info("abs", "path", me.a)
	}

	return me.a
}

func (me *target) convert() string {
	if me.a == "" {
		me.abs()
	}

	me.c = me.a[:strings.Index(me.a, filepath.Ext(me.a))] + ".pdf"

	if me.verbose {
		slog.Info("convert", "abs", me.a, "pdf", me.c)
	}

	return me.c
}

func main() {
	var (
		verbose bool
	)

	flag.Usage = func() {
		fmt.Fprintln(os.Stderr, "usage: excel2pdf.exe (-v) excel-file-path")
		flag.PrintDefaults()
	}

	flag.BoolVar(&verbose, "v", false, "verbose log output")
	flag.Parse()

	if flag.NArg() < 1 {
		flag.Usage()
		return
	}

	if err := run(&target{p: flag.Arg(0), verbose: verbose}); err != nil {
		slog.Error(err.Error())
	}
}

func run(p *target) error {
	if p.verbose {
		slog.Info("start")
		defer slog.Info("done")
	}

	quitFn := goxcel.MustInitGoxcel()
	defer quitFn()

	g, goxcelReleaseFn := goxcel.MustNewGoxcel()
	defer goxcelReleaseFn()

	_ = g.Silent(false)

	wbs, err := g.Workbooks()
	if err != nil {
		return err
	}

	wb, wbReleaseFn, err := wbs.Open(p.abs())
	if err != nil {
		return err
	}
	defer wbReleaseFn()

	err = wb.ExportAsFixedFormat(constants.XlTypePDF, p.convert())
	if err != nil {
		return err
	}

	return nil
}