Axolot Data

please answer the question

are there any news or progress with this feature? thank you for not ignoring the question.

Lars,

Is there any progress for pictures support for Excel 2007?
it's been a year since I asked :)

Mik

When loading file from XML, TSheet.AfterFileRead is called before Version is assigned in TXLSReadWriteII4.Read (SetVersion(xvExcel2007)), and therefore FDimension fields may be assigned wrong values.

Just want to add that on my system I have Japanese as a default locale. With this setting I cannot export Japanese texts into Excel file because function XLSUTF8EncodeWS works incorrectly when it assigns the result of conversion to back to WideString Result := WideString(S); My guess is that Delphi ...

I fixed it in my version of XLSXML4.pas by changing TXLSWriteXML.AddStr so that the wide string argument would be converted to UTF8 prior to writing to the stream. After that theme1.xml produced by Excel and by TXLSReadWriteII4 became identical. Here's the new code (note: "Windows" should ...

The effect is a result of running the project on Windows 7, which handles Asian fonts better than XP. Whe I run the project on XP, Excel has no problem opening the resulting document simply beacuse all pictograms are replaced with question marks. However, when I run it on Windows 7, Japanese and Chi...

Seems to be related to oriental font names. Starts working normally when I comment out the following group of lines (TXLSWrite2007XML.WriteTheme): '<a:font script="Jpan" typeface="ＭＳ Ｐゴシック" />' + '<a:font script="Hang" typeface="맑은 고딕" />' + '<a:font script=&q...

Hi, Here is the demo project text. Notes. 1. If lines between "BEGIN Portion can be removed"/"END Portion can be removed" are removed from the source code, the issue persists. In this case the resulting document is empty. 2. After "xls.Filename := 'c:\temp\t.xls';" unco...

Hi Lars,

I'll try create a small demo project and e-mail it to you.

Thanks for being responsive to my requests!

I’m getting the following message on attempt to open a file created by XLSReadWriteII4 in Excel 2007: “Excel found unreadable content in ‘t.xlsx’. Do you want to recover the content of this workbook?” After I agree the file is opened as “repaired” and following notification pops up: “Removed Records...

I don’t know if this already has been reported and fixed. It’s possible that I’m using the obsolete version of XLSUtils4.pas, though I downloaded it rather recently. I found that the encoding algorithm implemented in XLSUtils4.ColRowToRefStrEx12 works incorrectly for column numbers >675. Apparently ...

Lars, can I please have answers to the two follow-up questions below? These are key questions to make my purchasing decision. Thanks.

Thank you. a couple of follow-up questions: - if picture support is already in works in your development version, then perhaps estimates of the release can be shared with us; - am I correct that in this case essentially for Excel 2007 XlsMini covers everything that XLSReadWriteII does? if not, could...

Please let me know if current version 4 supports the following for Excel 2007 .xlsx format 1. retrieving the list of pictures on a worksheet, something like this: for i := 0 to XLS.Sheets.Count - 1 do begin sheet := XLS.Sheets[i]; for j := 0 to sheet.SheetPictures.Count - 1 do Name := sheet.SheetPic...