QElectroTech — Importing an Excel Table with data and frame/raster

Re: Importing an Excel Table with data and frame/raster

null@example.com (scorpio810) — Tue, 16 May 2023 16:29:25 +0000

See André Github repository:
https://github.com/acolomb/qet_terminal … in/samples

Example:
https://github.com/acolomb/qet_terminal … _-X20.html

Re: Importing an Excel Table with data and frame/raster

null@example.com (scorpio810) — Tue, 16 May 2023 10:34:07 +0000

I tried your HTML in qtdesigner tools (latest qtcreator package):



    
        Page Title
        
        
    
    
        

                
                    Omschrijving
                    Lichtpunt
                    WCD
                    3F
                    Verdeel doos
                    VA
                    

            
            
                
                    Keuken WCD 
                    2 
                    
                    
                    1 
                    3600

Omschrijving	Lichtpunt	WCD	3F	Verdeel doos	VA
Keuken WCD	2			1	3600

Same thing if I try with QET

Re: Importing an Excel Table with data and frame/raster

null@example.com (scorpio810) — Tue, 16 May 2023 10:04:11 +0000

I found new Qt code of richtext here, but license changed and isn't compatible, I think?

// Copyright (C) 2016 The Qt Company Ltd.
// SPDX-License-Identifier: LicenseRef-Qt-Commercial OR GPL-3.0-only WITH Qt-GPL-exception-1.0

https://github.com/qt/qttools/blob/dev/ … editor.cpp

Re: Importing an Excel Table with data and frame/raster

null@example.com (rvamerongen) — Tue, 16 May 2023 09:39:13 +0000

Very much thank you for your reply; I will look into this later.

Again thank you for your help.

Re: Importing an Excel Table with data and frame/raster

null@example.com (scorpio810) — Tue, 16 May 2023 05:37:49 +0000

I just found informations: Limited HTML styling as supported by the QT engine on the André Github repository: https://github.com/acolomb/qet_terminal_tables

https://doc.qt.io/qt-5/richtext-html-subset.html
https://docs.w3cub.com/qt~5.15/richtext-html-subset

Maybe it can help you?

The QET html text editor is a Qt code that is part of the designer that we integrated a long time ago... https://git.tuxfamily.org/qet/qet.git/t … s/richtext

History: https://git.tuxfamily.org/qet/qet.git/l … s/richtext

https://doc.qt.io/qt-6/designer-to-know.html

Re: Importing an Excel Table with data and frame/raster

null@example.com (scorpio810) — Fri, 12 May 2023 09:36:11 +0000

For font saw your settings text et independent text in Preferences menu, tab text in my example I switch to Arial font:


Page Title



Omschrijving

Lichtpunt

WCD

3F

Verdeel doos

VA


Keuken WCD 

2 



1 

3600

Omschrijving	Lichtpunt	WCD	3F	Verdeel doos	VA
Keuken WCD	2			1	3600

Re: Importing an Excel Table with data and frame/raster

null@example.com (rvamerongen) — Thu, 11 May 2023 21:24:58 +0000

Thank you for your reply; but those links doesn't help me much.

The text field changes hte code; and doesn't respect my settings.
If I have some HTML like



    
        Page Title
        
        
    
    
        

                
                    Omschrijving
                    Lichtpunt
                    WCD
                    3F
                    Verdeel doos
                    VA
                    

            
            
                
                    Keuken WCD 
                    2 
                    
                    
                    1 
                    3600

Omschrijving	Lichtpunt	WCD	3F	Verdeel doos	VA
Keuken WCD	2			1	3600

It changes it to


Page Title



Omschrijving

Lichtpunt

WCD

3F

Verdeel doos

VA


Keuken WCD 

2 



1 

3600

Omschrijving	Lichtpunt	WCD	3F	Verdeel doos	VA
Keuken WCD	2			1	3600

It doesn't respect my row height and a min max column width. Also it uses a hardcoded font, that maybe isn't available on other system and create there a different view. If I hardcode my own font choice it changes that too. And the border is no way a one pixel border anymore.

My question again, how can I avoid the changing and how can I let the text field respect my code?

This feels like a feature by the developer but that is actually a bug.

Re: Importing an Excel Table with data and frame/raster

null@example.com (scorpio810) — Wed, 10 May 2023 07:30:05 +0000

It's html 4 tags only and not support css
https://qelectrotech.org/forum/viewtopic.php?id=1590
https://qelectrotech.org/forum/viewtopi … 5765#p5765

I don't know if it's work with excel, but ok with Libreoffice, see these vidéo:
https://youtu.be/r2U2uAi7FfI

Re: Importing an Excel Table with data and frame/raster

null@example.com (rvamerongen) — Tue, 09 May 2023 20:55:35 +0000

hi, today, I did find some time, to play with HTML and the QET text fiel. I notice a very annoying issues; even when I add a very simple table inside the html source field, QET changes it to some thing that I didn't put there.

Is there a way that QET accept my input?
If I want f.e a one pixel thick border html code in the source how should I get the right result?

Sample


  
    
      col 1
      col 2
      col 3
      col 4
      col 5
    
    
      aaaaaaaaaaaaaaaaa
      bbbbb
      ccccccccc
      dd.dd
      eeee.e

I get a lot of garbage back with to much unnecessary style code.
If I create my own css then it get changed.

f.e


  
    
      Row 1, Cell 1
      Row 1, Cell 2
      Row 1, Cell 3
      Row 1, Cell 4
      Row 1, Cell 5
    
    
      Row 2, Cell 1
      Row 2, Cell 2
      Row 2, Cell 3
      Row 2, Cell 4
      Row 2, Cell 5
    
    


css
table {
  border-collapse: collapse;
}
td {
  border: 1px solid black;
  padding: 5px;
}

get changed to



    



Row 1, Cell 1      

Row 1, Cell 2      

Row 1, Cell 3      

Row 1, Cell 4      

Row 1, Cell 5        


Row 2, Cell 1      

Row 2, Cell 2      

Row 2, Cell 3      

Row 2, Cell 4      

Row 2, Cell 5

This is absolute not wanted. How can I get what I want?

I use data from an Excel sheet and create from within there some HTML with CSS and copy paste that in the QET text field. If I use the html code from QET as base I got a piece of text that is way to big to copy past.

Re: Importing an Excel Table with data and frame/raster

null@example.com (scorpio810) — Thu, 30 Mar 2023 17:19:25 +0000

Html table, sorry for typo.

Re: Importing an Excel Table with data and frame/raster

null@example.com (rvamerongen) — Thu, 30 Mar 2023 17:06:44 +0000

scorpio810 wrote:

Great,
you could import xml table, see:

Nice
Yummy

Re: Importing an Excel Table with data and frame/raster

null@example.com (scorpio810) — Thu, 30 Mar 2023 13:37:35 +0000

Great,
you could import xml table, see:

https://youtu.be/FV4UlPHM7dU

Re: Importing an Excel Table with data and frame/raster

null@example.com (rvamerongen) — Thu, 30 Mar 2023 12:49:57 +0000

thank you, it works.
I need to alter some lining thickness but so far so good.

Maybe, if you want, create a sticky with all those valuable tips. I did search the web and YT, but I did't find this one.

Thank ypu again.

Re: Importing an Excel Table with data and frame/raster

null@example.com (scorpio810) — Thu, 30 Mar 2023 12:12:30 +0000

Hi,

like this?

https://youtu.be/r2U2uAi7FfI

Importing an Excel Table with data and frame/raster

null@example.com (rvamerongen) — Thu, 30 Mar 2023 11:55:59 +0000

Hi,

Is there a way to import an Excel table completely with raster, headers and data?

If not, is there a way to import CSV data in a table?

Thank you

col 1	col 2	col 3	col 4	col 5
aaaaaaaaaaaaaaaaa	bbbbb	ccccccccc	dd.dd	eeee.e

Row 1, Cell 1	Row 1, Cell 2	Row 1, Cell 3	Row 1, Cell 4	Row 1, Cell 5
Row 2, Cell 1	Row 2, Cell 2	Row 2, Cell 3	Row 2, Cell 4	Row 2, Cell 5