Title: Export current day date
Last modified: March 10, 2020

---

# Export current day date

 *  Resolved [imborx](https://wordpress.org/support/users/imborx/)
 * (@imborx)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/export-current-day-date/)
 * Hi,
 * I love this plugin but I have 3 questions:
 * 1) I’m not able to add the current day in the “Set up fields to export”. Where
   can I see a field that points the day when the export is done? I only see the
   date for the order, the date for payment… and I just want the current date.
 * 2) this is more secundary but… its posible to export the excel with some background
   title fields? Like this: [https://i.gyazo.com/d45946267ac32eb98a02de281fca9b5c.png](https://i.gyazo.com/d45946267ac32eb98a02de281fca9b5c.png)
 * 3) Finally, is there any way to control the witdh of the columns? Now seems to
   be autofit with the column title, but I want some rows narrower. On the left 
   what I want and on the right what I have: [https://i.gyazo.com/e095a3d0894530a6b1f482038a7a1774.png](https://i.gyazo.com/e095a3d0894530a6b1f482038a7a1774.png)
 * Thanks!
    -  This topic was modified 6 years, 3 months ago by [imborx](https://wordpress.org/support/users/imborx/).
    -  This topic was modified 6 years, 3 months ago by [imborx](https://wordpress.org/support/users/imborx/).

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/export-current-day-date/#post-12528929)
 * Hello
 * Please, follow to [https://algolplus.freshdesk.com/support/solutions/articles/25000016635-add-calculated-field-for-order-](https://algolplus.freshdesk.com/support/solutions/articles/25000016635-add-calculated-field-for-order-)
   
   use metakey “current_day” and this PHP code.
 *     ```
       add_filter('woe_get_order_value_current_day',function ($value, $order,$fieldname) {
         return current_time("Y-m-d");
       },10,3);
       ```
   
 * To color cells — add this PHP code to section “Misc Settings” too.
 *     ```
       add_action( 'woe_xls_print_footer', function ($objXls,$formatter) {
        $sheet = $objXls->getActiveSheet();
        $sheet->getStyle('A1')->applyFromArray(
           array(
               'fill' => array(
                   'type' => PHPExcel_Style_Fill::FILL_SOLID,
                   'color' => array('rgb' => 'FF0000')
               )
           )
        );
       }, 10, 2); 
       ```
   
 * thanks, Alex
 *  Thread Starter [imborx](https://wordpress.org/support/users/imborx/)
 * (@imborx)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/export-current-day-date/#post-12529049)
 * Hi Alex [@algolplus](https://wordpress.org/support/users/algolplus/), I really
   appreciate your help. Your answer was super fast!
 * 1) Done!
 * 2) About colloring cells, that works… but if I tried to color more than 1 cell
   using “$sheet->getStyle(‘A1, B1, F1,’)” I get an error. So I dont know how can
   I set different cells.
 * 3) Is there any way to control the witdh of the columns? Now seems to be autofit
   with the column title, but I want some rows narrower. On the left what I want
   and on the right what I have: [https://i.gyazo.com/e095a3d0894530a6b1f482038a7a1774.png](https://i.gyazo.com/e095a3d0894530a6b1f482038a7a1774.png)
 * 4) How can I set a conditional for a column? For example: if billing_state “X,
   Y or Z” show 48, if billing_state “A, B or C” show 14.
 * Thanks!
    -  This reply was modified 6 years, 3 months ago by [imborx](https://wordpress.org/support/users/imborx/).
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/export-current-day-date/#post-12529275)
 * 2) try this version
 *     ```
       add_action( 'woe_xls_print_footer', function ($objXls,$formatter) {
        $sheet = $objXls->getActiveSheet();
        $sheet->getStyle('A1')->applyFromArray(
           array(
               'fill' => array(
                   'type' => PHPExcel_Style_Fill::FILL_SOLID,
                   'color' => array('rgb' => 'FF0000')
               )
           )
        );
        $sheet ->duplicateStyle($sheet->getStyle('A1'),   'B1');
        $sheet ->duplicateStyle($sheet->getStyle('A1'),   'F1');
       }, 10, 2); 
       ```
   
 * 3) is ” Auto column width” ON in section XLS?
 * 4) Please, follow to [https://algolplus.freshdesk.com/support/solutions/articles/25000016635-add-calculated-field-for-order-](https://algolplus.freshdesk.com/support/solutions/articles/25000016635-add-calculated-field-for-order-)
   
   use metakey “state_calc” and this PHP code.
 *     ```
       add_filter('woe_get_order_value_state_calc',function ($value, $order,$fieldname) {
         $state = $order->get_billing_state();
         if($state == "A" OR $state == "B" OR $state=="C" ) $value =  14;
         if($state == "X" OR $state == "Y" OR $state=="Z" ) $value =  48;
         return $value;
       },10,3);
       ```
   
 *  Thread Starter [imborx](https://wordpress.org/support/users/imborx/)
 * (@imborx)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/export-current-day-date/#post-12529418)
 * Hi again [@algolplus](https://wordpress.org/support/users/algolplus/)
 * 2) Awesome!
 * 3) That works perfect
 * 4) I follow the steps and unfortunately it didn’t print anything in that column.
   I’m 100% sure that I’ve add the meta_key correctly adding “state_calc”. You can
   check that somethings it’s not working at all: [https://i.gyazo.com/448347b5b8fdaf1a324d92f647633f4c.png](https://i.gyazo.com/448347b5b8fdaf1a324d92f647633f4c.png)
 * 5) Is there any way to show in a column just the private order notes?
 * Thanks again, your plugin it’s amazing!!
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/export-current-day-date/#post-12530493)
 * 4) I think you should use state abbreviations.
    for example, “PM” instead of “
   Baleares”. see mapping at page [https://github.com/woocommerce/woocommerce/blob/master/i18n/states.php#L296](https://github.com/woocommerce/woocommerce/blob/master/i18n/states.php#L296)
 * 5) Please, follow to [https://algolplus.freshdesk.com/support/solutions/articles/25000016635-add-calculated-field-for-order-](https://algolplus.freshdesk.com/support/solutions/articles/25000016635-add-calculated-field-for-order-)
   
   use metakey “priv_notes” and this PHP code.
 *     ```
       add_filter('woe_get_order_value_priv_notes',function ($value, $order,$fieldname) {
       	$notes = wc_get_order_notes( array(	'order_id' => $order->get_id() ) );
       	$comments = array();
       	if ( $notes ) {
       		foreach ( $notes as $note ) {
       			if( $note->customer_note OR 'system' === $note->added_by)
       				continue;
       			$comments[] = $note->content;
       		}
       	}
       	return implode( "\n", $comments );
        },10,3);
       ```
   
 *  Thread Starter [imborx](https://wordpress.org/support/users/imborx/)
 * (@imborx)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/export-current-day-date/#post-12539774)
 * Hi [@algolplus](https://wordpress.org/support/users/algolplus/),
 * 4) & 6) Works pretty well, really appreciate your help 🙂
 * Finally, is there any way to have different group saved fields to export? I would
   like to have some of them to export manually and some of them automatically.
 * Thanks!
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/export-current-day-date/#post-12539826)
 * you have to use tab “Profiles”, but it’s pro feature 😉

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Export current day date’ is closed to new replies.

 * ![](https://ps.w.org/woo-order-export-lite/assets/icon-256x256.png?rev=1365554)
 * [Advanced Order Export For WooCommerce](https://wordpress.org/plugins/woo-order-export-lite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-order-export-lite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-order-export-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-order-export-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-order-export-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-order-export-lite/reviews/)

 * 7 replies
 * 2 participants
 * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/export-current-day-date/#post-12539826)
 * Status: resolved