ms excel funktsiyalari

PPTX 13 sahifa 84,5 KB Bepul yuklash

13 sahifa

FaylHub.uz

Telegram orqali yuklab olish

Hajm 84,5 KB

Fayl turi PPTX

Sahifalar 13

Yangilangan Dek 2025

Sahifa ko'rinishi (5 sahifa)

Pastga aylantiring 👇

1 / 13

$kiritish va chiqarish oqimlari. ma'lumotlarni ms excelga yuklash funktsiyalar. s++da funktsiyani ifodalanishi. ms excel dasturiga ma’lumotlarni export qilish uchun: quyidagi “header” fayllar yuklanadi: #include #include global o’zgaruvchilarni “variant” universal ma’lumot tipida e’lon qilamiz: variant app, books, book, sheets, sheet, cell; button1 obyektini yaratib uning ichiga: void __fastcall tform1::button19click(tobject *sender) { app=createoleobject("excel.application"); app.olepropertyset("visible", true); app.olepropertyset("sheetsinnewworkbook",5); books=app.olepropertyget("workbooks"); books.oleprocedure("add"); book=books.olepropertyget("item", 1); sheets=book.olepropertyget("worksheets"); sheet=sheets.olepropertyget("item", 1); sheet.olepropertyset("name", "yangilist"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,1); cell.olepropertyset("value", "salom"); } #include #include variant vvarapp, vvarbooks, vvarbook, vvarsheets, vvarsheet, vvarcells, vvarcell; //…………………………………………. void __fastcall tform1::button1click(tobject *sender){ vvarapp=createoleobject("excel.application"); vvarapp.olepropertyset("visible", true); vvarbooks=vvarapp.olepropertyget("workbooks"); vvarapp.olepropertyset("sheetsinnewworkbook",5); vvarbooks.oleprocedure("add"); vvarbook=vvarbooks.olepropertyget("item", 1); vvarsheets=vvarbook.olepropertyget("worksheets"); vvarsheet=vvarsheets.olepropertyget("item", 1); vvarsheet.olepropertyset("name", "yangilist"); vvarsheet=vvarsheets.olepropertyget("item", 3); vvarsheet.olepropertyset("name", "ikki"); //2-satr,3-ustunga salom yozuvini chiqarish "ikki“ listiga vvarcell=vvarsheet.olepropertyget("cells").olepropertyget("item", 2,3); vvarcell.olepropertyset("value", "salom"); } void __fastcall tform1::button1click(tobject *sender){ vvarapp=createoleobject("excel.application"); vvarapp.olepropertyset("visible", true); vvarbooks=vvarapp.olepropertyget("workbooks"); vvarapp.olepropertyset("sheetsinnewworkbook",5); vvarbooks.oleproced$

2 / 13

$ure("add"); vvarbook=vvarbooks.olepropertyget("item", 1); vvarsheets=vvarbook.olepropertyget("worksheets"); vvarsheet=vvarsheets.olepropertyget("item", 1); vvarsheet.olepropertyset("name", "yangilist"); vvarsheet=vvarsheets.olepropertyget("item", 3); vvarsheet.olepropertyset("name", "ikki"); for(int i=1; i #include variant vvarapp, vvarbooks, vvarbook, vvarsheets, vvarsheet, vvarcells, vvarcell; void __fastcall tform1::button1click(tobject *sender) { vvarapp=createoleobject("excel.application"); vvarapp.olepropertyset("visible", true); vvarapp.olepropertyget("application").olepropertyget("workbooks").oleprocedure("open","c:\\bonus\\journal.xlsx"); vvarapp.olepropertyset("visible", true); } exceldan ma’lumotlarni import qilish #include #include variant vvarapp, vvarbooks, vvarbook, vvarsheets, vvarsheet, vvarcells, vvarcell; void __fastcall tform1::button1click(tobject *sender) { vvarapp=createoleobject("excel.application"); vvarapp.olepropertyset("visible", true); vvarapp.olepropertyget("application").olepropertyget("workbooks").oleprocedure("open","c:\\bonus\\journal.xlsx"); vvarapp.olepropertyset("visible", true); vvarbooks=vvarapp.olepropertyget("workbooks"); vvarbook=vvarbooks.olepropertyget("item", 1); vvarsheets=vvarbook.olepropertyget("worksheets"); vvarsheet=vvarsheets.olepropertyget("item", 1); //vvarsheet.olepropertyset("name", "yangilist"); vvarcell=vvarsheet.olepropertyget("cells").olepropertyget("item", 5,2); ansistring ad=vvarcell.olepropertyget("value"); listbox1->items->add(ad); vvarcell=vvarsheet.olepropertyget("cells").olepropertyget("item", 6,2); ad=vvarcell.olepropertyget("value"); listbox1->items->add(ad); vvarcell=vvarsheet.olepropertyget("cells").olepropertyget("item", 7,2); ad=vvarcell.olepropertyget("value"); listbox1->items->add(ad); …………. } void __fastcall tform1::button19click(tobject *sender) { app=createoleobject("excel.application"); app.olepropertyset("visible", true); app.olepropertyset("sheetsinnewworkbook",5); books=app.oleproperty$

3 / 13

$get("workbooks"); books.oleprocedure("add"); book=books.olepropertyget("item", 1); sheets=book.olepropertyget("worksheets"); sheet=sheets.olepropertyget("item", 1); sheet.olepropertyset("name", "yangilist"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,1); cell.olepropertyset("value", "id"); adotable1->first(); for (int i=0; i recordcount; i++){ cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,1); cell.olepropertyset("value", adotable1->fieldbyname("id")->asvariant); cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,2); adotable1->next(); } } void __fastcall tform1::button19click(tobject *sender) { app=createoleobject("excel.application"); app.olepropertyset("visible", true); app.olepropertyset("sheetsinnewworkbook",5); books=app.olepropertyget("workbooks"); books.oleprocedure("add"); book=books.olepropertyget("item", 1); sheets=book.olepropertyget("worksheets"); sheet=sheets.olepropertyget("item", 1); sheet.olepropertyset("name", "yangilist"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,1); cell.olepropertyset("value", "¹"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,2); cell.olepropertyset("value", "familiya"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,3); cell.olepropertyset("value", "ism"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,4); cell.olepropertyset("value", "tug'ilgan_sanasi"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,5); cell.olepropertyset("value", "tel"); adotable1->first(); for (int i=0; i recordcount; i++){ cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,1); cell.olepropertyset("value", adotable1->fieldbyname("¹")->asvariant); cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,2); cell.olepropertyset("value", adotable1->fieldbyname("familiya")->asvariant); cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,3); cell.olepropertyset("value", adotable1->fieldbyname("ism")->asvariant); cell=she$

4 / 13

et.olepropertyget("cells").olepropertyget("item", i+2,4); cell.olepropertyset("value", adotable1->fieldbyname("tug'ilgan_sanasi")->asvariant); cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,5); cell.olepropertyset("value", adotable1->fieldbyname("tel")->asvariant); adotable1->next(); } } eksportning so’ngi qiymatini label ga chiqarish … adotable1->next(); } ansistring a=cell.olepropertyget("value"); label1->caption=a; } e’tiboringiz uchun rahmat /docprops/thumbnail.jpeg ‘mapaywottapa ms excelra wna

5 / 13

Ko'proq o'qimoqchimisiz?

Barcha 13 sahifani Telegram orqali bepul yuklab oling.

To'liq faylni yuklab olish

"ms excel funktsiyalari" haqida

kiritish va chiqarish oqimlari. ma'lumotlarni ms excelga yuklash funktsiyalar. s++da funktsiyani ifodalanishi. ms excel dasturiga ma’lumotlarni export qilish uchun: quyidagi “header” fayllar yuklanadi: #include #include global o’zgaruvchilarni “variant” universal ma’lumot tipida e’lon qilamiz: variant app, books, book, sheets, sheet, cell; button1 obyektini yaratib uning ichiga: void __fastcall tform1::button19click(tobject *sender) { app=createoleobject("excel.application"); app.olepropertyset("visible", true); app.olepropertyset("sheetsinnewworkbook",5); books=app.olepropertyget("workbooks"); books.oleprocedure("add"); book=books.olepropertyget("item", 1); sheets=book.olepropertyget("worksheets"); sheet=sheets.olepropertyget("item", 1); sheet.olepropertyset("name", "yangilist"); cell=she...

Bu fayl PPTX formatida 13 sahifadan iborat (84,5 KB). "ms excel funktsiyalari"ni yuklab olish uchun chap tomondagi Telegram tugmasini bosing.

Teglar: ms excel funktsiyalari PPTX 13 sahifa Bepul yuklash Telegram

ms excel funktsiyalari

Sahifa ko'rinishi (5 sahifa)

Ko'proq o'qimoqchimisiz?

"ms excel funktsiyalari" haqida

O'xshash fayllar