Scarica il file excel di tuo interesse: contiene numerose informazioni utili.
I File sono suddivisi in colonne e contengono i campi informazioni Titolo, ISBN, Collana, Autori, prezzo, Formato, Pagine e Uscita: seleziona le colonne di tuo interesse.
Dal menù Ordina e filtra, scegli la funzione di ordinamento di tuo interesse.
Vicino al titolo di ogni colonna apparirà l'icona del filtro: clicca per accedere al menù che ti permetterà di ordinare i contenuti.
Se le indicazioni presenti in questa guida non fossero sufficienti (o se cerchi informazioni più dettagliate) ti consigliamo di consultare la guida ufficiale di Excel cliccando il pulsante sottostante.
GUIDA EXCEL 2007 GUIDA EXCEL 2010
©2009-2024 Antonio Vallardi Editore s.u.r.l.
P.IVA 11920250153
Via Gherardini 10 – 20145 Milano
T. +39 02 34597660
Informativa sull’utilizzo dei cookie
# | type | message |
---|---|---|
1 | Context | initialization |
2 | Controller | initialization |
3 | Routing | match route [librai_excel] "/area-librai/excel" |
4 | Request | request parameters array ( 'module' => 'librai', 'action' => 'excel',) |
5 | Controller | dispatch request |
6 | Filter | executing filter "sfRenderingFilter" |
7 | Filter | executing filter "sfWebDebugFilter" |
8 | Filter | executing filter "sfCommonFilter" |
9 | Filter | executing filter "sfFlashFilter" |
10 | Filter | executing filter "sfExecutionFilter" |
11 | Action | call "libraiActions->executeExcel()" |
12 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
13 | Creole | prepareStatement(): SELECT collane.POSIZIONE, collane.PUBBLICA, collane.PARENT_ID, collane.COLLANA, collane.TITOLO, collane.DESCRIZIONE, collane.PDF, collane.ISSUU_EMBED, collane.SLUG, collane.CREATED_AT, collane.UPDATED_AT, collane.ID, UPPER(collane.TITOLO) FROM collane WHERE collane.PARENT_ID IS NULL AND collane.PUBBLICA=? ORDER BY collane.POSIZIONE ASC,UPPER(collane.TITOLO) ASC |
14 | Creole | executeQuery(): [0.46 ms] SELECT collane.POSIZIONE, collane.PUBBLICA, collane.PARENT_ID, collane.COLLANA, collane.TITOLO, collane.DESCRIZIONE, collane.PDF, collane.ISSUU_EMBED, collane.SLUG, collane.CREATED_AT, collane.UPDATED_AT, collane.ID, UPPER(collane.TITOLO) FROM collane WHERE collane.PARENT_ID IS NULL AND collane.PUBBLICA=1 ORDER BY collane.POSIZIONE ASC,UPPER(collane.TITOLO) ASC |
15 | View | initialize view for "librai/excel" |
16 | View | render "sf_app_dir/modules/librai/templates/excelSuccess.php" |
17 | View | initialize view for "librai/_menu" |
18 | View | render "sf_app_dir/modules/librai/templates/_menu.php" |
19 | View | initialize view for "librai/_notice" |
20 | View | render "sf_app_dir/modules/librai/templates/_notice.php" |
21 | View | decorate content with "sf_app_dir/templates/layout.php" |
22 | View | render "sf_app_dir/templates/layout.php" |
23 | View | initialize view for "global/_meta" |
24 | View | render "sf_app_dir/templates/_meta.php" |
25 | View | initialize view for "global/_tracker" |
26 | View | render "sf_app_dir/templates/_tracker.php" |
27 | View | initialize view for "global/_ie6nomore" |
28 | View | render "sf_app_dir/templates/_ie6nomore.php" |
29 | View | initialize view for "global/_header" |
30 | View | render "sf_app_dir/templates/_header.php" |
31 | PartialHelper | call "banners->executeTop()" |
32 | Creole | prepareStatement(): SELECT banner.PRODOTTI_ID, banner.ATTIVO, banner.TITOLO, banner.IMMAGINE, banner.URL, banner.SCADENZA, banner.POSIZIONE, banner.CREATED_AT, banner.UPDATED_AT, banner.ID FROM banner WHERE banner.ATTIVO=? AND banner.POSIZIONE=? AND banner.SCADENZA>=CURRENT_DATE ORDER BY RAND() ASC |
33 | Creole | applyLimit(): SELECT banner.PRODOTTI_ID, banner.ATTIVO, banner.TITOLO, banner.IMMAGINE, banner.URL, banner.SCADENZA, banner.POSIZIONE, banner.CREATED_AT, banner.UPDATED_AT, banner.ID FROM banner WHERE banner.ATTIVO=1 AND banner.POSIZIONE='t' AND banner.SCADENZA>=CURRENT_DATE ORDER BY RAND() ASC, offset: 0, limit: 1 |
34 | Creole | executeQuery(): [0.52 ms] SELECT banner.PRODOTTI_ID, banner.ATTIVO, banner.TITOLO, banner.IMMAGINE, banner.URL, banner.SCADENZA, banner.POSIZIONE, banner.CREATED_AT, banner.UPDATED_AT, banner.ID FROM banner WHERE banner.ATTIVO=1 AND banner.POSIZIONE='t' AND banner.SCADENZA>=CURRENT_DATE ORDER BY RAND() ASC LIMIT 1 |
35 | View | initialize view for "global/_menu" |
36 | View | render "sf_app_dir/templates/_menu.php" |
37 | View | initialize view for "global/_ricerca" |
38 | View | render "sf_app_dir/templates/_ricerca.php" |
39 | PartialHelper | get slot "vetrina" |
40 | PartialHelper | get slot "editoriale" |
41 | PartialHelper | get slot "menu" |
42 | PartialHelper | call "banners->executeSide()" |
43 | Creole | prepareStatement(): SELECT banner.PRODOTTI_ID, banner.ATTIVO, banner.TITOLO, banner.IMMAGINE, banner.URL, banner.SCADENZA, banner.POSIZIONE, banner.CREATED_AT, banner.UPDATED_AT, banner.ID FROM banner WHERE banner.ATTIVO=? AND banner.POSIZIONE=? AND banner.SCADENZA>=CURRENT_DATE ORDER BY RAND() ASC |
44 | Creole | applyLimit(): SELECT banner.PRODOTTI_ID, banner.ATTIVO, banner.TITOLO, banner.IMMAGINE, banner.URL, banner.SCADENZA, banner.POSIZIONE, banner.CREATED_AT, banner.UPDATED_AT, banner.ID FROM banner WHERE banner.ATTIVO=1 AND banner.POSIZIONE='r' AND banner.SCADENZA>=CURRENT_DATE ORDER BY RAND() ASC, offset: 0, limit: 1 |
45 | Creole | executeQuery(): [0.32 ms] SELECT banner.PRODOTTI_ID, banner.ATTIVO, banner.TITOLO, banner.IMMAGINE, banner.URL, banner.SCADENZA, banner.POSIZIONE, banner.CREATED_AT, banner.UPDATED_AT, banner.ID FROM banner WHERE banner.ATTIVO=1 AND banner.POSIZIONE='r' AND banner.SCADENZA>=CURRENT_DATE ORDER BY RAND() ASC LIMIT 1 |
46 | PartialHelper | call "promo->executeLinguadelmese()" |
47 | Creole | prepareStatement(): SELECT lingua_del_mese.TAG_ID, lingua_del_mese.CREATED_AT, lingua_del_mese.UPDATED_AT, tag.TAG, tag.SUPERTAG, tag.COLLANE_ID, tag.SLUG, tag.CREATED_AT, tag.UPDATED_AT, tag.ID FROM lingua_del_mese, tag WHERE lingua_del_mese.TAG_ID=tag.ID |
48 | Creole | executeQuery(): [0.23 ms] SELECT lingua_del_mese.TAG_ID, lingua_del_mese.CREATED_AT, lingua_del_mese.UPDATED_AT, tag.TAG, tag.SUPERTAG, tag.COLLANE_ID, tag.SLUG, tag.CREATED_AT, tag.UPDATED_AT, tag.ID FROM lingua_del_mese, tag WHERE lingua_del_mese.TAG_ID=tag.ID |
49 | View | initialize view for "promo/_linguadelmese" |
50 | View | render "sf_app_dir/modules/promo/templates/_linguadelmese.php" |
51 | PartialHelper | get slot "tags" |
52 | PartialHelper | call "banners->executeBottom()" |
53 | Creole | prepareStatement(): SELECT banner.PRODOTTI_ID, banner.ATTIVO, banner.TITOLO, banner.IMMAGINE, banner.URL, banner.SCADENZA, banner.POSIZIONE, banner.CREATED_AT, banner.UPDATED_AT, banner.ID FROM banner WHERE banner.ATTIVO=? AND banner.POSIZIONE=? AND banner.SCADENZA>=CURRENT_DATE ORDER BY RAND() ASC |
54 | Creole | applyLimit(): SELECT banner.PRODOTTI_ID, banner.ATTIVO, banner.TITOLO, banner.IMMAGINE, banner.URL, banner.SCADENZA, banner.POSIZIONE, banner.CREATED_AT, banner.UPDATED_AT, banner.ID FROM banner WHERE banner.ATTIVO=1 AND banner.POSIZIONE='b' AND banner.SCADENZA>=CURRENT_DATE ORDER BY RAND() ASC, offset: 0, limit: 1 |
55 | Creole | executeQuery(): [0.25 ms] SELECT banner.PRODOTTI_ID, banner.ATTIVO, banner.TITOLO, banner.IMMAGINE, banner.URL, banner.SCADENZA, banner.POSIZIONE, banner.CREATED_AT, banner.UPDATED_AT, banner.ID FROM banner WHERE banner.ATTIVO=1 AND banner.POSIZIONE='b' AND banner.SCADENZA>=CURRENT_DATE ORDER BY RAND() ASC LIMIT 1 |
56 | View | initialize view for "global/_footer" |
57 | View | render "sf_app_dir/templates/_footer.php" |
58 | View | initialize view for "global/_corporate" |
59 | View | render "sf_app_dir/templates/_corporate.php" |
60 | View | initialize view for "global/_credits_rss" |
61 | View | render "sf_app_dir/templates/_credits_rss.php" |
--- parameterHolder: symfony/default: action: excel module: librai attributeHolder: symfony/default:
--- cookies: httpHeaders: Content-Type: text/html; charset=utf-8 parameterHolder: helper/asset/auto/httpmeta: Content-Type: text/html; charset=utf-8 helper/asset/auto/javascript: /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main helper/asset/auto/meta: title: Estrai in EXCEL | Vallardi helper/asset/auto/stylesheet: /sf/sf_web_debug/css/main: symfony/response/http/headers: Content-Type: text/html; charset=utf-8 symfony/view/asset: javascripts_included: stylesheets_included:
--- app_admin_email: info@vallardi.it app_admin_name: Antonio Vallardi Editore app_agenda_homepage_limit: 2 app_assets_version: ?v=20161219 app_contact_fax: +39 02 436923 app_contact_recievers_email_list: vendite: name: vendite email: info@vallardi.it segreteria: name: segreteria editoriale email: info@vallardi.it ufficiostampa: name: ufficio stampa email: ufficiostampa@vallardi.it info: name: informazioni generiche email: info@vallardi.it app_contact_tel: +39 02 34597660 app_dir_album: uploads/album/ app_dir_autori: uploads/autori/ app_dir_banners: uploads/banners/ app_dir_cataloghi: uploads/pdf/ app_dir_covers: app_dir_covers_norobocop: uploads/catalogo/ app_dir_covers_old: /srv/www/vallardi/vallardi.it/www/web/uploads/catalogo/ app_dir_indici: uploads/indici/ app_dir_mediateca: uploads/mediateca/ app_dir_press: uploads/press/ app_full_w: 140 app_mesi_0: Gennaio app_mesi_1: Febbraio app_mesi_10: Novembre app_mesi_11: Dicembre app_mesi_2: Marzo app_mesi_3: Aprile app_mesi_4: Maggio app_mesi_5: Giugno app_mesi_6: Luglio app_mesi_7: Agosto app_mesi_8: Settembre app_mesi_9: Ottobre app_novita_area_limit: 4 app_novita_mesi_da_uscita: 12 app_pager_first: « app_pager_gap: 10 app_pager_last: » app_pager_next: › app_pager_ordine: - data - titolo app_pager_previous: ‹ app_pp_h: 147 app_pp_w: 103 app_preferiti_area_limit: 3 app_preferiti_homepage_limit: 4 app_preview_w: 100 app_primo_piano_area_limit: 2 app_primo_piano_homepage_limit: 1 app_rss_limit: 20 app_search_highlight: <span class="highlight">%s</span> app_search_min_chars: 3 app_search_results_per_page: 12 app_site_short_title: | Vallardi app_site_title: Antonio Vallardi Editore s.u.r.l. app_site_url: http://www.vallardi.it app_tags_show_few: 12 app_tags_show_many: 3 app_vetrina_h: 138 app_vetrina_homepage_limit: 5 app_vetrina_mesi_da_uscita: 2 app_vetrina_w: 95 mod_banners_enabled: 1 mod_banners_is_internal: mod_banners_view_class: sfPHP mod_librai_enabled: 1 mod_librai_is_internal: mod_librai_view_class: sfPHP mod_promo_enabled: 1 mod_promo_is_internal: mod_promo_view_class: sfPHP sf_admin_web_dir: /sf/sf_admin sf_app: frontend sf_app_config_dir: /srv/www/vallardi/vallardi.it/www/apps/frontend/config sf_app_config_dir_name: config sf_app_dir: /srv/www/vallardi/vallardi.it/www/apps/frontend sf_app_i18n_dir: /srv/www/vallardi/vallardi.it/www/apps/frontend/i18n sf_app_i18n_dir_name: i18n sf_app_lib_dir: /srv/www/vallardi/vallardi.it/www/apps/frontend/lib sf_app_lib_dir_name: lib sf_app_module_action_dir_name: actions sf_app_module_config_dir_name: config sf_app_module_dir: /srv/www/vallardi/vallardi.it/www/apps/frontend/modules sf_app_module_dir_name: modules sf_app_module_i18n_dir_name: i18n sf_app_module_lib_dir_name: lib sf_app_module_template_dir_name: templates sf_app_module_validate_dir_name: validate sf_app_module_view_dir_name: views sf_app_template_dir: /srv/www/vallardi/vallardi.it/www/apps/frontend/templates sf_app_template_dir_name: templates sf_apps_dir_name: apps sf_autoloading_functions: sf_available: 1 sf_base_cache_dir: /srv/www/vallardi/vallardi.it/www/cache/frontend sf_bin_dir: /srv/www/vallardi/vallardi.it/www/batch sf_bin_dir_name: batch sf_cache: sf_cache_dir: /srv/www/vallardi/vallardi.it/www/cache/frontend/dev sf_cache_dir_name: cache sf_calendar_web_dir: /sf/calendar sf_charset: utf-8 sf_check_lock: sf_check_symfony_version: sf_compressed: sf_config_cache_dir: /srv/www/vallardi/vallardi.it/www/cache/frontend/dev/config sf_config_dir: /srv/www/vallardi/vallardi.it/www/config sf_config_dir_name: config sf_data_dir: /srv/www/vallardi/vallardi.it/www/data sf_data_dir_name: data sf_debug: 1 sf_default_action: index sf_default_module: homepage sf_doc_dir: /srv/www/vallardi/vallardi.it/www/data/doc sf_doc_dir_name: doc sf_enabled_modules: - default sf_environment: dev sf_error_404_action: error404 sf_error_404_module: errors sf_error_reporting: 24567 sf_escaping_method: ESC_ENTITIES sf_escaping_strategy: bc sf_etag: sf_i18n: sf_i18n_cache_dir: /srv/www/vallardi/vallardi.it/www/cache/frontend/dev/i18n sf_lazy_cache_key: sf_lib_dir: /srv/www/vallardi/vallardi.it/www/lib sf_lib_dir_name: lib sf_log_dir: /srv/www/vallardi/vallardi.it/www/log sf_log_dir_name: log sf_logging_enabled: 1 sf_logging_history: 2 sf_logging_level: debug sf_logging_period: 1 sf_logging_purge: 1 sf_logging_rotate: 1 sf_login_action: login sf_login_module: default sf_max_forwards: 5 sf_model_dir_name: model sf_model_lib_dir: /srv/www/vallardi/vallardi.it/www/lib/model sf_module_cache_dir: /srv/www/vallardi/vallardi.it/www/cache/frontend/dev/modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: sf_orm: propel sf_path_info_array: SERVER sf_path_info_key: PATH_INFO sf_plugins_dir: /srv/www/vallardi/vallardi.it/www/plugins sf_plugins_dir_name: plugins sf_propel_impersonator_plugin: 1 sf_prototype_web_dir: /sf/prototype sf_rich_text_js_dir: js/tiny_mce sf_root_cache_dir: /srv/www/vallardi/vallardi.it/www/cache sf_root_dir: /srv/www/vallardi/vallardi.it/www sf_routing_defaults: sf_culture: en sf_secure_action: secure sf_secure_module: default sf_standard_helpers: - Partial - Cache - Form - Date - Text - Utility sf_strip_comments: 1 sf_suffix: .html sf_symfony_data_dir: /srv/www/vallardi/vallardi.it/www/config/../lib/vendor/symfony/data sf_symfony_lib_dir: /srv/www/vallardi/vallardi.it/www/config/../lib/vendor/symfony/lib sf_template_cache_dir: /srv/www/vallardi/vallardi.it/www/cache/frontend/dev/template sf_test: sf_test_cache_dir: /srv/www/vallardi/vallardi.it/www/cache/frontend/dev/test sf_test_dir: /srv/www/vallardi/vallardi.it/www/test sf_test_dir_name: test sf_timeout: 1800 sf_timer_start: 1716179571.7837 sf_unavailable_action: unavailable sf_unavailable_module: default sf_upload_dir: /srv/www/vallardi/vallardi.it/www/web/uploads sf_upload_dir_name: uploads sf_url_format: PATH sf_use_database: 1 sf_use_flash: 1 sf_use_process_cache: 1 sf_use_security: 1 sf_validation_error_class: form_error sf_validation_error_id_prefix: error_for_ sf_validation_error_prefix: ↓ sf_validation_error_suffix: ↓ sf_web_debug: 1 sf_web_debug_web_dir: /sf/sf_web_debug sf_web_dir: /srv/www/vallardi/vallardi.it/www/web sf_web_dir_name: web
--- cookie: vallardi: jjsdei4ka1dpk3nv1vh8dn1vlf env: files: get: post: server: CONTEXT_DOCUMENT_ROOT: /srv/www/vallardi/vallardi.it/www/web CONTEXT_PREFIX: DOCUMENT_ROOT: /srv/www/vallardi/vallardi.it/www/web GATEWAY_INTERFACE: CGI/1.1 HTTPS: 1 HTTP_ACCEPT: */* HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate HTTP_COOKIE: vallardi=jjsdei4ka1dpk3nv1vh8dn1vlf HTTP_FRONT_END_HTTPS: on HTTP_HOST: www.vallardi.it HTTP_REFERER: https://www.vallardi.it/index_dev.php/area-librai.html HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) HTTP_X_FORWARDED_FOR: 3.145.110.176, 3.145.110.176 HTTP_X_HAPREQ_ID: 664AD273-C11BCA9301BB1704-46A726E HTTP_X_SERVER: waf147 HTTP_X_SSL: 0 PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin PATH_INFO: /area-librai/excel.html PATH_TRANSLATED: redirect:/index.php/excel.html PHP_SELF: /index_dev.php/area-librai/excel.html QUERY_STRING: REMOTE_ADDR: 10.1.2.241 REMOTE_PORT: 48450 REQUEST_METHOD: GET REQUEST_SCHEME: http REQUEST_TIME: 1716179571 REQUEST_TIME_FLOAT: 1716179571.783 REQUEST_URI: /index_dev.php/area-librai/excel.html SCRIPT_FILENAME: /srv/www/vallardi/vallardi.it/www/web/index_dev.php SCRIPT_NAME: /index_dev.php SCRIPT_URI: http://www.vallardi.it/index_dev.php/area-librai/excel.html SCRIPT_URL: /index_dev.php/area-librai/excel.html SERVER_ADDR: 10.100.0.47 SERVER_ADMIN: webmaster@maurispagnol.it SERVER_NAME: www.vallardi.it SERVER_PORT: 80 SERVER_PROTOCOL: HTTP/1.1 SERVER_SIGNATURE: | <address>Apache/2.4.59 (Debian) Server at www.vallardi.it Port 80</address> SERVER_SOFTWARE: Apache/2.4.59 (Debian) session: symfony/user/sfUser/attributes: symfony/user/sfUser/authenticated: symfony/user/sfUser/credentials: symfony/user/sfUser/culture: en symfony/user/sfUser/lastRequest: 1716179571
--- php: 7.4.33 os: Linux webphp7 5.10.0-29-amd64 #1 SMP Debian 5.10.216-1 (2024-05-03) x86_64 extensions: - Core - date - libxml - openssl - pcre - zlib - filter - hash - Reflection - SPL - session - standard - sodium - apache2handler - mysqlnd - PDO - xml - calendar - ctype - curl - dom - mbstring - FFI - fileinfo - ftp - gd - gettext - iconv - imagick - imap - intl - json - ldap - exif - memcache - mysqli - odbc - pdo_mysql - PDO_ODBC - Phar - posix - readline - shmop - SimpleXML - soap - sockets - sysvmsg - sysvsem - sysvshm - tokenizer - uploadprogress - xmlreader - xmlwriter - xsl - zip - Zend OPcache
type | calls | time (ms) |
---|---|---|
Configuration | 14 | 1.22 |
Action "librai/excel" | 1 | 1.98 |
Database | 5 | 1.79 |
View "Success" for "librai/excel" | 1 | 6.76 |
Partial "librai/_menu" | 1 | 0.78 |
Partial "librai/_notice" | 1 | 0.04 |
Partial "global/_meta" | 1 | 0.14 |
Partial "global/_tracker" | 1 | 0.02 |
Partial "global/_ie6nomore" | 1 | 0.02 |
Partial "global/_header" | 1 | 1.22 |
Component "banners/top" | 1 | 0.74 |
Partial "global/_menu" | 1 | 0.13 |
Partial "global/_ricerca" | 1 | 0.03 |
Component "banners/side" | 1 | 0.45 |
Component "promo/linguadelmese" | 1 | 0.45 |
Partial "promo/_linguadelmese" | 1 | 0.11 |
Component "banners/bottom" | 1 | 0.37 |
Partial "global/_footer" | 1 | 0.20 |
Partial "global/_corporate" | 1 | 0.04 |
Partial "global/_credits_rss" | 1 | 0.06 |