Please can u add support for cocoapod?, this is an awesome project but is hard to devs like me that's don't use SPM and instead use cocoapod. Thanks for your hard work !

Hi I've created a new project and import the library with SPM. But It is not compiling due to find xlsxwriter.h

#ifdef _WIN32
#include "C:/vcpkg/installed/x64-windows/include/xlsxwriter.h"
#elif __APPLE__
#include "/opt/homebrew/include/xlsxwriter.h" //   <- Here is indicating '/opt/homebrew/include/xlsxwriter.h' file not found
#elif __linux__
#include "/usr/local/include/xlsxwriter.h"
#endif

For sure I don't have home-brew installed on my machine. But I guess if I had installed it would work on my machine only not on the real hardware.
Is there any way to accomplish this requirement?

open /var/mobile/Containers/Data/Application/45AA94F9-7192-4B74-8025-277A3038AB8A/Documents [ERROR] workbook_close(): Error creating '/var/mobile/Containers/Data/Application/45AA94F9-7192-4B74-8025-277A3038AB8A/DocumentsDoc.xlsx'. System error = Operation not permitted lxw_error(rawValue: 2)

have this error each time when I try workbook_close(workbook)

Basically, I need to share the composed document through AirDrop. How to do it?

Hi! Great work on this lib. I was wondering if there is a reason why the SPM branch shouldn't be merged in to main?
Reason I'm asking is these branches appear to have diverged more than just the way the xlxswriter library is included and it would be great to have a single source of truth.
I'd be happy to work on a PR to help things along.

I could be wrong, but it looks like you're accidentally initializing the start and end of a column range to the same end index.

Additionally, the init() method accepts a UInt32 for the first column index. That should be UInt16 according to libxlsxwriter.

I've added support for writing rich strings to the wrapper, but my custom fork has very extensive changes in style and formatting, so a direct PR isn't possible. I'm putting my code here so that you can adapt it to your style and add it to the wrapper.

Fragment Struct

This simple object holds information about one fragment of a rich string. In your module, ExcelFormat is named just Format, I think:

///
///  Represents one fragment of a rich string: a substring and, optionally, a format to apply to that substring.
///
///  Warning: Libxlsxwriter will throw an error if two consecutive fragments of a rich string have the same format object.
///
struct ExcelRichStringFragment
{
    var format: ExcelFormat?
    var string: String
    
    init(_ string: String, format: ExcelFormat? = nil)
    {
        self.string = string
        self.format = format
    }
}

Worksheet Addition

This method accepts an array of ExcelRichStringFragment and writes the rich string to a particular cell:

    ///
    ///  Writes a rich string to a given cell by assembling the rich string fragments. The final format parameter should contain
    ///  attributes that apply to the cell, but not the string (border type/color, background color, etc.) Including such attributes 
    ///  in the formats applied to each string fragment will fail to apply them to the cell.
    ///
    ///  WARNING: It is an error for two consecutive fragments to share the same format object, or for a fragment to have an empty string.
    ///
    @discardableResult func writeRichString(fragments: [ExcelRichStringFragment], at cell: ExcelCell, format: ExcelFormat? = nil) throws -> ExcelWorksheet
    {
        guard !fragments.isEmpty else {
            return self
        }

        let mainFormat = format?.lxw_format
        
        var rawTuples: [lxw_rich_string_tuple] = []
        for fragment: ExcelRichStringFragment in fragments
        {
            let f = fragment.format?.lxw_format
            let s = UnsafeMutablePointer<Int8>(mutating: (fragment.string as NSString).utf8String)
            
            let t = lxw_rich_string_tuple(format: f, string: s)
            rawTuples.append(t)
        }
        
        rawTuples.withUnsafeMutableBufferPointer { p in
            
            guard let arrBaseAddress = p.baseAddress else { return }

            var pointersToEachArrayElement: [UnsafeMutablePointer<lxw_rich_string_tuple>?] = Array(arrBaseAddress ..< arrBaseAddress.advanced(by: p.count))
            pointersToEachArrayElement.append(nil)
            
            _ = pointersToEachArrayElement.withUnsafeMutableBufferPointer { q in
                worksheet_write_rich_string(lxw_worksheet, cell.row, cell.col, q.baseAddress, mainFormat)
            }
        }
        
        return self
    }

Example Usage

let f1: ExcelFormat = book.addFormat()
f1.fontColor(.red)
        
let f2: ExcelFormat = book.addFormat()
f2.fontColor(.blue)

let frag1 = ExcelRichStringFragment("This is", format: f1)
let frag2 = ExcelRichStringFragment(" a test.", format: f2)
        
try sheet.writeRichString(fragments: [frag1, frag2], at: "D10")

Hello. Does this library support merging cells? If so, how ?

Good afternoon.
I have some doubts about this library.

1. How can I read an existing xlsx file and modify it?
2. How can I create cells with selectors and set the allowed values in an array?

It would be cool if you could also publish the package via cocoapods.

This line is incorrect:

Using .path() will return an empty string for URLs such as: mailto:[email protected]. This empty string will cause libxlsxwriter to fail with a very cryptic error: "ignoring NULL function parameter".

mailto: URLs are listed as explicitly supported by libxlsxwriter, so this wrapper should handle them correctly. To do that, use .absoluteString() on the URL instead of .path(). This works for all well-formed URIs that libxlswriter supports, as shown:

The behavior for other URIs, such as local filesystem URLs, is undefined.

xlsxwriter.h:1:10: 'xlsxwriter.h' file not found with include; use "quotes" instead

Cell_Range: Could not build Objective-C module 'Cxlsxwriter'

error: cannot assign value of type 'UnsafeMutablePointer' (aka 'UnsafeMutablePointer') to type 'UnsafePointer' (aka 'UnsafePointer')